Dropping a constraint

• kalikal

  Old Hand

  Points: 303

  More actions

  October 3, 2002 at 3:13 am

  #159171

  Hi folks

  I want to write generic code which will drop a given column from a given table. However I need a way to find out if there is a constraint on the column and if so drop this first and then drop the constraint.

  I am new to sql server and could do with some help...

  Thanks.

• Clive Strong

  SSChampion

  Points: 11222

  More actions

  October 3, 2002 at 3:23 am

  #437717

  Hi,

  This query will list all constraints on a given table.

  select *

  from sysobjects

  where parent_obj in (select id from sysobjects where name = '<TableName>') and type = 'C'

  Clive Strong

  clivestrong@btinternet.com