問題描述

我正在嘗試在數據庫中創建一些表，但是這些表沒有出現在我的對象資源管理器視圖中.

I am trying to create some tables within a database, however the tables are not appearing in my object explorer view.

我的代碼如下:

use testDB
GO

create table dbo.teacher (id varchar(5), name varchar(24));
insert into teacher values ('dm112', 'Magro, Deirdre');
insert into teacher values ('je232', 'Elkner, Jeff');
insert into teacher values ('cm147', 'Meyers, Chris');
insert into teacher values ('kr387', 'Reed, Kevin');


create table dbo.course (
    number varchar(6),
    name varchar(24),
    credits int,
    teacherid varchar(6) 
);
insert into course values ('SDV100', 'College Success Skills', 1, 'dm112');
insert into course values ('ITD110', 'Web Page Design I', 3, 'je232');
insert into course values ('ITP100', 'Software Design', 3, 'je232');
insert into course values ('ITD132', 'Structured Query Language', 3, 'cm147');
insert into course values ('ITP140', 'Client Side Scripting', 4, 'kr378');
insert into course values ('ITP225', 'Web Scripting Languages', 4, 'kr387');


create table dbo.student (id varchar(3), name varchar(24));
insert into student values ('411', 'Perez, Gustavo');
insert into student values ('412', 'Rucker, Imani');
insert into student values ('413', 'Gonzalez, Alexis');
insert into student values ('414', 'Melgar, Lidia');


create table dbo.enrolled (studentId varchar(3), courseNumber varchar(6));
insert into enrolled values ('411', 'SDV100');
insert into enrolled values ('411', 'ITD132');
insert into enrolled values ('411', 'ITP140');
insert into enrolled values ('412', 'ITP100');
insert into enrolled values ('412', 'ITP14p');
insert into enrolled values ('412', 'ITP225');
insert into enrolled values ('413', 'ITD132');
insert into enrolled values ('413', 'ITP225');
insert into enrolled values ('414', 'SDV100');
insert into enrolled values ('414', 'ITD110');

我在發帖前查了一下，發現了這個確切的問題:

I looked this up before posting and found this exact question:

使用 T- 創建表SQL - 在對象資源管理器中看不到創建的表

但是，他使用的是tempdb"，而我不是.

However, he was using "tempdb", which I am not.

我運行了查詢

select name, type_desc from testDB.sys.objects

返回:

name          type_desc
---------------------------
...
teacher       USER_TABLE
course        USER_TABLE 
student       USER_TABLE
enrolled      USER_TABLE
...

我可以對這些表進行修改、選擇、刪除等操作，但我看不到它們.我錯過了什么嗎?另一個問題提出了測試"和生產"的前景?他們沒有詳細說明，谷歌也沒有幫助我

I can modify, select, drop, etc. on these tables, but I cannot see them. Am I missing something? Another question brought up the prospect of "test" and "production"? They didn't go into much detail and google did not help me

:(

感謝您提供的任何幫助.

Thank you for any help you can offer.

下面的卡爾找到了解決方案！盡管在對象資源管理器上單擊刷新 (F5) 不會更新數據庫視圖，但右鍵單擊數據庫并單擊刷新會更新表.

Karl below found the solution! Although clicking refresh (F5) on the object explorer does not update the database view, right clicking on the database and clicking refresh updates the tables.

推薦答案

如果您在對象資源管理器中打開了表節點并且在運行 DDL 后不刷新，則會發生這種情況.令人討厭的是，SSMS 在 DDL 后不會自動刷新資源管理器.可通過對象資源管理器中的右鍵單擊上下文菜單進行刷新.

This would happen if you have the tables node open in object explorer and don't refresh after running your DDL. It is annoying that SSMS doesn't autorefresh explorer after DDL. Refresh is available via the right-click context menu in object explorer.

這篇關于在對象資源管理器中看不到創建的表 - Microsoft SQL Management Studio的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！