View Table Definition

2016 (13.x) and later versions

Azure

SQL Managed Instance

Analytics Platform System (PDW)

You can display properties for a table in SQL Server by using SQL Server Management Studio or

Transact-SQL.

You can only see properties in a table if you either own the table or have been granted

permissions to that table.

1. In Object Explorer, select the table for which you want to show properties.

2. Right-click the table and select

from the shortcut menu. For more information,

see

Table Properties - SSMS.

You can script out existing objects from the Object Explorer in SSMS. For more information, see

Generate Scripts.

1. In

, connect to an instance of Database Engine.

2. On the Standard bar, select.

3. Copy and paste the following example into the query window and select. The

example executes the system stored procedure

to return all column information

for the specified object. For more information, see

sp_help.

sp_help