View the Table Definition
You can display properties for a table in SQL Server 2017 by using SQL Server Management Studio or Transact-SQL.
In This Topic
Before you begin:
To display table properties, using:
Before You Begin
You can only see properties in a table if you either own the table or have been granted permissions to that table.
Using SQL Server Management Studio
To show table properties in the Properties window
In Object Explorer, select the table for which you want to show properties.
Right-click the table and choose Properties from the shortcut menu. For more information, see Table Properties - SSMS.
We are listening: If you find something outdated or incorrect in this article, such as a step or a code example, please tell us. You can click the This page button in the Feedback section at the bottom of this page. We read every item of feedback about SQL, typically the next day. Thanks.
To show table properties
In Object Explorer, connect to an instance of Database Engine.
On the Standard bar, click New Query.
Copy and paste the following example into the query window and click Execute. The example returns all columns from the
sys.tablescatalog view for the specified object.
SELECT * FROM sys.tables WHERE object_id = 1973582069;
For more information, see sys.tables (Transact-SQL).