Clever Geek Handbook

SQL Server Management Studio: Object Explorer does not display tables

I have LocalDB running and I can log into it through SQL Server Management Studio. I have provided my custom db_datareader and other roles, but the Object Explorer tree still does not list tables under Databases> System Databases> Master.

I can create tables and select, etc. They appear in schema information tables with a "wizard" as the table catalog. I created a view and it shows up under Views, so the problem seems to be limited to tables.

I don't know what else to try - any idea?

+3
ssms


source to share


No one has answered this question yet

Check out similar questions:

560
What's the best way to automatically generate INSERT statements for a SQL Server table?
552
Sql error "Changes cannot be saved". ► Prevent saving changes that require re-creating the table.
213
How to connect to a local instance of SQL Server 2008 Express
166
SQL Server 2008 cannot log on with newly created user
156
How can I change the default database to SQL Server without using MS SQL Server Management Studio?
50
How to generate scripts to recreate a table using SQL Server Management Studio?
43
How to View Stored Procedure Code in SQL Server Management Studio
nine
Indexed views in SQL Server 2014 Object Explorer without index node
4
SQL group tables in SQL Server Management Studio object explorer
1
SQL Server Management Studio not showing all dependencies


More articles:


All Articles
Loading...
X
Show
Funny
Dev
Pics