Get identity and default values from system tables

• brettk_1

  SSC Rookie

  Points: 27

  More actions

  March 13, 2008 at 10:08 am

  #95897

  Hi all,

  I am creating a vb.net program to update a database schema.

  The databases will be SQL Server 2000 based and the update will be based on information in the system tables.

  I'm sure I will run into many problems but the first two are as follows.

  1. I need to know the identity seed and identity increment values of a column.

  2. How do I get the default value of a column (if it has a default value).

  Any help would be greatly appreciated.

  Thanks.

• shamas saeed

  SSC-Addicted

  Points: 458

  More actions

  March 14, 2008 at 4:23 am

  #789524

  this is for default value

  SELECT cdefault FROM syscolumns

  and identity

  @@Ident_Current ('TableName')