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: Intermediate
Jan 25, 2006

Determine Whether a Given Column Name Is an Identity or Not

There are actually two ways in which you can find out whether a given column name is an identity or not in SQL Server:
  1. Method One:
    
    Select ColumnProperty(Object_id('Table_Name'), 'FieldName', 'IsIdentity')
    
  2. Method Two:
    
    Declare @colName varchar(100)
    Declare @RetColName varchar(100)
    
    Set @colName = 'FieldName' 
    
    --Status column = 128 means its an identity column
    Select @RetColName=[name] from syscolumns where status=128 and id=(select id
    from sysobjects where name='Table_Name')
    
    If @colName = @RetColName
       Print 'Its Identity'
    Else
       Print 'Not an identity column'
    

Vadivel Mohanakrishnan
 
Comment and Contribute

 

 

 

 

 


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

 

 

Sitemap