468,257 Members | 1,430 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

how to drop constraints within a table

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
1 1554
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.

Similar topics

2 posts views Thread by James Knowlton | last post: by
2 posts views Thread by Christopher Weaver | last post: by
2 posts views Thread by bluelaser | last post: by
5 posts views Thread by Markus | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.