Table with identity in a database....

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  June 29, 2005 at 1:49 am

  #87937

  I need a code or store procedure (T-SQL) to find all tables in a database with identity...

  Any suggestion will be appreciated

  Thank a lot

   

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  June 29, 2005 at 2:03 am

  #569225

  SELECT [id], [name], OBJECTPROPERTY([id], 'TableHasIdentity') AS HasIdentity

  FROM sysobjects

  WHERE xtype = 'U'

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/