問題描述

使用微軟 SQL

嘗試使用 T-SQL 語言創(chuàng)建表.代碼非常簡單，執(zhí)行成功，但我在對象資源管理器中沒有看到創(chuàng)建的表.嘗試重新啟動(dòng)/重新連接/刷新/重新執(zhí)行 - 結(jié)果相同 - 看不到此表.也嘗試手動(dòng)執(zhí)行(通過在對象資源管理器中的樹中右鍵單擊鼠標(biāo) - 一切正常 - 可以看到剛剛創(chuàng)建的表).

Try to create table using T-SQL language. Code is very simple, executed succesfull, but i don't see created table in Object Explorer. Try restart/reconnect/refresh/reexecuting - result the same - cant see this table. Also try to do it manually (by right click mouse in tree in the Object explorer - all ok - can see just created table).

代碼:

USE tempdb 
    IF OBJECT_ID('dbo.Employees','U') IS NOT NULL
DROP TABLE dbo.Employees;
CREATE TABLE dbo.Employees
(
    empid INT NOT NULL,
    firstname VARCHAR(30) NOT NULL,
    lastname VARCHAR(30) NOT NULL,
    hiredate DATE NOT NULL,
    mgrid INT NULL,
    ssn VARCHAR(20) NOT NULL,
    salary MONEY NOT NULL
);

屏幕截圖

覺得這個(gè)問題很簡單，但是試著找答案，稍微堆疊一下.為什么我沒有看到剛剛創(chuàng)建的表?此代碼是否適用于創(chuàng)建表?

Think that the problem is very simple, but try to find answer and stack a little bit. Why i don't see just created table? Is this code is correct for creating table?

推薦答案

這是因?yàn)槟?TempDB 中創(chuàng)建該表.

It is because you are creating that table in TempDB.

從此下拉列表中選擇正確的數(shù)據(jù)庫.

From this drop down select the right DataBase.

或

在執(zhí)行創(chuàng)建表語句之前執(zhí)行以下語句.類似的東西

execute the following statement before you execute the Create Table Statement. Something like

USE TestDB
GO

Create Table ....

這篇關(guān)于使用 T-SQL 創(chuàng)建表 - 在對象資源管理器中看不到創(chuàng)建的表的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！