>This query will list all the FK constraints for a given table. Wrap it up in a cursor and you'll it.
>
>

>SELECT T.Table_Name, RC.Constraint_Name
>FROM
>	INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE T INNER JOIN
>	INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC ON
>	T.Constraint_Name = RC.Constraint_Name
>WHERE T.Table_Name = 'titleauthor'
>

>
>It should work for SQL Server 7.0 and up.
>
>-Mike

Thanks Mike! I'm surprised there is not already some stored procedure to remove contraints.