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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Syntax of Deleting Constraints in Table Schema

Author  Topic 

aravindt77
Posting Yak Master

120 Posts

Posted - 2007-06-24 : 23:50:05
Hi All ,

Warm Wishes For All

What is the syntax for Deleting or Droping the Constraint
Foreign Key

Its very urgent

Plz do the needful

Aravind

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-06-24 : 23:59:35
alter table <table name> drop constraint <constraint name>


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

aravindt77
Posting Yak Master

120 Posts

Posted - 2007-06-25 : 00:34:28
Thank u so much Khtan

My Wishes for U..
Go to Top of Page
   

- Advertisement -