View the Table Definition
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
You can display properties for a table in SQL Server 2016 by using SQL Server Management Studio or Transact-SQL.
In This Topic
You can only see properties in a table if you either own the table or have been granted permissions to that table.
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.tables catalog view for the specified object.
SELECT * FROM sys.tables WHERE object_id = 1973582069;
For more information, see sys.tables (Transact-SQL).