Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Feb 26, 2008

Obtain Information About Table Columns in Microsoft SQL Server

To obtain information about table columns in Microsoft SQL Server, use the INFORMATION_SCHEMA.COLUMNS view:

SELECT COLUMN_NAME,
columnproperty(OBJECT_ID(TABLE_NAME),
   COLUMN_NAME, 'IsIdentity') as IsIdentity,
ORDINAL_POSITION, IS_NULLABLE, DATA_TYPE, 
CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION, COLLATION_NAME, 
CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLUMNS 
   WHERE TABLE_NAME = 'your_table_name'
ORDER BY TABLE_NAME, ORDINAL_POSITION, COLUMN_NAME

Alexander Ocher
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap