By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

how to drop constraints within a table

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You're in the wrong newsgroup.
Either way try the ALTER TABLE statement which I presume TSQL provides.

Cheers
Serge
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.