I am using SQL Server 2000 and i would like to find out how to write
the syntax in stored procedure for dropping the constraints within the
table. Below is the
request for my case:

1)Perform "duplicate" checking on the cardsmart database for rd_awards
table before dropping the existing Rewards_Catalog_Product_CS table in
web database

2)If gift code "duplicate", Rewards_Catalog_Product_CS table will not
be drop but constraints within the table will be drop.