CODEWITHSUNDEEP
t-sqlsql-server-2012
cat
cat

Reputation: 263

How to view schema of Microsoft SQL Server?

I need a schema of Microsoft SQL Server like in this screenshot:

enter image description here

I created a schema according to Create Schema in SSMS , but I can not view it in Microsoft SQL Server Management Studio. 

Databases -> [YourDatabase] -> Security -> Schemas -> (right-click) New schema

Where to view schema?

I go to Security -> Schemas -> myschemaname click on it and appears nothing.

Thanks for help, I am new to Microsoft SQL Server.

Upvotes: 19

Views: 70030

Answers (1)

Lukasz Szozda
Lukasz Szozda

Reputation: 175726

Based on screenshot I assume that you want database diagram.

SSMS -> Object Explorer -> Database Name -> Database Diagram-> RC (Right Click) -> New Database diagram -> Add table

More info: Getting started with SQL Server database diagrams

Upvotes: 16

Related Questions