How to check table structure in SQL server 2008
In this article I will show how to check table structure in SQL server 2008
To check table structure in SQL server do following.
1. Open the query window.
2. Write the table name and select the table name.
3. And then press Alt +F1
The following information about the table will be displayed.
a) Table name, table owner and datetime when created.
b) Table columns with datatype
c) Identity column if any
d) Column name of GUID datatype
e) Tables data file location and filegroup
f) Index, primary key
g) List of constraints on the table.
Happy reading.......