To determine table detail like column name & data types for each individual table ,Index, primary key, foreign keys etc, sp_help is one of the best way.
Syntax of sp_help is very simple as shown below
sp_help tableName
GO
Instead of writing sp_help tablename you can get same information by highlighting table and press ALT+ F1
Note: if you just right sp_help and run it then all the objects of database will be listed down as a result.
Enjoy 
No comments:
Post a Comment