CODEWITHSUNDEEP
sql-serversql-server-2008
Nandu
Nandu

Reputation: 1

View another schemas objects in object explorer . SQL server 2008

I need to see the objects from another schema that I have read permissions from in the object explorer. I can select from them in the query window but I do not see them in the object explorer.

Upvotes: 0

Views: 454

Answers (1)

gbn
gbn

Reputation: 432271

If you have read permissions, they will be in Object Explorer.

The sorting is schema.objectname.

If you still don't see them, try closing and reopening SSMS because it does cache information.

If still not visible, you don't have permissions says Metadata Visibility

Upvotes: 2

Related Questions