View previous topic :: View next topic
|
Author |
Message |
raghs_sir
New User
Joined: 19 Jul 2005 Posts: 9 Location: Chennai
|
|
|
|
hi,
can we delete a foreign key constraint by using alter statement?
i tried it out but its not working.... |
|
Back to top |
|
|
arock08
New User
Joined: 15 Apr 2005 Posts: 4
|
|
|
|
Yes, you can drop the foreign using the ALTER command. The syntax is below.
ALTER TABLE -table-name─ DROP FOREIGN KEY ─constraint-name─.
Please let me know what is the error you get? |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
hi frnd,
hope the drop foreign key will not work in alter table. |
|
Back to top |
|
|
|