Menu
I need a schema of Microsoft SQL Server like in this screenshot:
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.
672
To create a schemaIn Object Explorer, expand the Databases folder. Expand the database in which to create the new database schema. Right-click the Security folder, point to New, and select Schema. In the Schema - New dialog box, on the General page, enter a name for the new schema in the Schema name box.
To show the schema, we can use the DESC command. This gives the description about the table structure.
You can turn on schema view by selecting Schema view in the View tab.
We can use SSMS in-built object search functionality to find out specific objects across all online databases in SQL instance. Navigate to View-> Object Explorer Details in SSMS. You can use a keyboard shortcut F7 to open it.
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
191
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
