Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to view schema of Microsoft SQL Server?

Tags:

tsql

sql-server-2012

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.

like image 672
cat Avatar asked Feb 17 '18 10:02

cat

People also ask

How do I find my SQL database schema?

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.

What is the command to view schema in SQL?

To show the schema, we can use the DESC command. This gives the description about the table structure.

How do I view a schema?

You can turn on schema view by selecting Schema view in the View tab.

How do I find schema objects in SQL Server?

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.

1 Answers

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

like image 191
Lukasz Szozda Avatar answered Oct 20 '22 04:10

Lukasz Szozda
Sign in to Comment

Related questions

How to get rid of double quote from column's value?
SQL, Incorrect syntax on CASE statement near the keyword 'FROM'
ORDER BY in a Sql Server 2008 view
T-SQL query performance puzzle: Why does using a variable make a difference?
Make Linq to Sql generate T-SQL with ISNULL instead of COALESCE
Need to get attribute name-value pairs for root element only, in T-SQL query
Interesting behavior in "NOEXEC ON"
Using Dapper-dot-net, how do I map SQL Time column to a .Net type?
How to reduce SQL Server transaction log usage
COUNT (DISTINCT column_name) Discrepancy vs. COUNT (column_name) in SQL Server 2008?
Performance using DISTINCT COUNT
Sorting hierarchical text in SQL
How to use CDATA in SQL XML
Insert Into temp table from a stored procedure that returns multiple result sets
How can I structure a query to give me only the rows that match ALL values in a CSV list of IDs in T-SQL
FileTable Delimited String Split
Capturing multiple error messages from a single statement inside TRY CATCH
Nested Query or Joins
Joining against a CSV Column in SQL Server
Calculating SQL Server ROW_NUMBER() OVER() for a derived table

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!