SQL 2000: Query Column’s Default Value

SELECT ct.text [default_value]
    FROM syscolumns c
    INNER
    JOIN sysconstraints cr
      ON c.id = cr.id
     AND c.colid = cr.colid
    INNER
    JOIN syscomments ct
      ON cr.constid = ct.id
    WHERE c.id = OBJECT_ID('my_table')
      AND c.name = 'my_fieldname'
      AND cr.status & 5 = 5 -- DEFAULT constraint
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s