User Id :    Password :      New Member   Forgot Password  
 
How to check table structure in SQL server 2008
Description How to check table structure in SQL server 2008   No. of Views     4377
  Rating     0
Author Najmul Hoda   Posted On     05 Dec 2011
Tags SQL SERVER    

Sample Code   Download Code

 

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.......

 

About Author

About Author He is a team lead, having 8+ years of experience. He loves writing technical article for .Net developers. Najmul Hoda
No Photo
 
Country United States
Company BirlaSoft
Home Page http://www.magixchat.com

Rate this article

Rating options from poor, fair, good, very good to excelent.  
 

Comments

   
Write your comment here.
Comment
Verification Code