View SQL table schema or definition

To view table schema definition one option is to right click table name view in design mode, other simple option is to view it through following query:

sp_help 'table_name'

It shows following:

• When table/object is created & its owner
• DDL of table (column name & its type & other definition details)
• Identity, indexes, contraint & foreign key this table/object is reference as

If You Enjoyed This, Take 5 Seconds To Share It

• 
• 
• 
• 
• 
•