使用 T-SQL 创建表 - 在对象资源管理器中看不到创建的表

2021-09-10 00:00:00 sql tsql sql-server

使用微软 SQL

尝试使用 T-SQL 语言创建表.代码非常简单，执行成功，但我在对象资源管理器中没有看到创建的表.尝试重新启动/重新连接/刷新/重新执行 - 结果相同 - 看不到此表.也尝试手动执行(通过在对象资源管理器中的树中右键单击鼠标 - 一切正常 - 可以看到刚刚创建的表).

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
);

屏幕截图

觉得这个问题很简单，但是试着找答案，稍微堆叠一下.为什么我没有看到刚刚创建的表?此代码是否适用于创建表?

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?

推荐答案

这是因为您正在 TempDB 中创建该表.

It is because you are creating that table in TempDB.

从此下拉列表中选择正确的数据库.

From this drop down select the right DataBase.

或

在执行创建表语句之前执行以下语句.类似的东西

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

USE TestDB
GO

Create Table ....

相关文章