Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gvd
Starting Member
21 Posts |
 Posted - 2005-11-01 : 15:04:34
|
| Hi people,Pls can any one tell me how to remove a unique constraint on a field in a particular table (nb: this is not the primary key field). I want to do this from query analyzer.So let's say the name of the unique constraint is:'IX_Forms_FormNumber'and the name of my table is:'Forms'.i know how to do this in enterprise manager, but i was just wondering if I could do this in QA. Thanks a bunch |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-11-01 : 15:28:52
|
| check out "Alter Table" in Books Online. Should be something like this:alter table [forms] drop constraint [IX_Forms_FormNumber]Be One with the OptimizerTG |
 |
|
|
gvd
Starting Member
21 Posts |
Posted - 2005-11-01 : 15:40:41
|
| Hey TG thanks, will ckeck it right away |
|
|
|
gvd
Starting Member
21 Posts |
Posted - 2005-11-01 : 15:41:46
|
| Thanks once again TG, I have all the info I need |
|
|
|
|
|
|
Remove a unique constraint