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 |
|
ganeshkumar08
Posting Yak Master
187 Posts |
 Posted - 2008-09-27 : 04:59:09
|
| Hi All,Can any one help me in droping foreign key from a table.I used this syntax ALTER TABLE dbo.TrendMATCHESDROP FOREIGN KEY TrendCUP_ROUND_TrendMATCHES_FK1I am getting error as belowMsg 156, Level 15, State 1, Line 2Incorrect syntax near the keyword 'FOREIGN'.I need only query to delete the Foreign KeyThanksGanesh KumarSolutions are easy. Understanding the problem, now, that's the hard part |
|
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2008-09-27 : 05:13:04
|
| try,ALTER TABLE dbo.TrendMATCHESDROP CONSTRAINT TrendCUP_ROUND_TrendMATCHES_FK1 |
 |
|
|
ganeshkumar08
Posting Yak Master
187 Posts |
Posted - 2008-09-27 : 05:15:20
|
| Thanks for u r response sunil.. it worked perfectly...Solutions are easy. Understanding the problem, now, that's the hard part |
|
|
|
|
|
|
Help me in droping Foreign key