Advertiser Disclosure
TODAY'S HEADLINES
|
ARTICLE ARCHIVE
|
FORUMS
|
TIP BANK
Android Development Center
Windows Mobile Dev Center
Sponsored Research
Editorial Research
eBook Library for Technology Professionals
DevX: .NET Zone
Windows Mobile Dev Center
DevX: Java Zone
DevX: C++ Zone
DevX: Web Development Zone
HTML5 Development Center
DevX: Architecture Zone
DevX: Database Dev Zone
DevX: Security Zone
DevX: Open Source Zone
DevX: Enterprise Zone
DevX: Wireless Zone
Windows Mobile Dev Center
Android Development Center
Field Guide to the Mobile Development Platform Landscape
Move to the Future with Multicore Code
C++0x: The Dawning of a New Standard
Going Mobile: Getting Your Apps On the Road
Software as a Service: Building On-Demand Applications in the Cloud
A New Era for Rich Internet Applications
The Road to Ruby
Vista's Bounty: Surprising Features Take You Beyond .NET 3.0
Special Report: Virtual Machines Usher In a New Era
Java/.NET Interop: Bridging Muddled Waters
Wireless Special Report: Marching Toward Mobility
Home Page for Special Report: Ensuring Successful Web Services Today and Tomorrow
How to Create a Disaster Recovery Plan
Special Report: Judging Java
Past C/C++ 10-Minute Solutions
Past Java 10-Minute Solutions
Past DHTML 10-Minute Solutions
Past DevX 10-Minute Solutions
Past DB2 10-Minute Solutions
Past Visual Basic 10-Minute Solutions
Past XML 10-Minute Solutions
DevXtra Blog: The Agile Architecture Revolution
DevXtra Blog: Enterprise Issues For Developers
Specialized Dev Zones
Research Center
eBook Library
.NET
Java
C++
Web Dev
Architecture
Database
Security
Open Source
Enterprise
Mobile
Special Reports
10-Minute Solutions
DevXtra Blogs
Slideshow
Sign up for e-mail newsletters from DevX
How to Call a Stored Procedure via the JdbcTemplate
How to Increment Integers
Determine if String str2 is a Rotation of String str1
Convert a Given Code Point to a String
Understanding java.net.PasswordAuthentication
Home
»
Tip Bank
»
Database Development
»
SQL
»
Transact-sql
Comment on this Article
Language: SQL
Expertise: Intermediate
Aug 2, 2006
Determine Whether a Table Has an Identity Column
This code is for MSSQL Server, but applicable for MS SSQL Server 7 or above. Check in T-SQL:
SELECT OBJECTPROPERTY(object_id('TableToBeChecked'), 'TableHasIdentity')
SQL Server returns
1
if the table has an identity column,
0
if it doesn't.
Jaya Nehru Kumar
Submit a Tip
Browse "Database Development" Tips
Browse All Tips
Thanks for your registration, follow us on our social networks to keep up-to-date
