Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Drop FK For A Specific Table Expand / Collapse
Author
Message
Posted Friday, April 25, 2008 11:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, June 1, 2016 9:24 PM
Points: 57, Visits: 100
Comments posted to this topic are about the item Drop FK For A Specific Table
Post #490859
Posted Friday, April 4, 2014 3:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 11, 2014 1:28 AM
Points: 4, Visits: 16
I wrote this query but its not working

ALTER TABLE Vrhicle
DROP FOREIGN KEY fk_PerVrhicle

It create error near

FOREIGN word

please explain whats the problem
Post #1558405
Posted Friday, May 9, 2014 2:32 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, June 1, 2016 9:24 PM
Points: 57, Visits: 100
ALTER TABLE Vrhicle
DROP CONSTRAINT fk_PerVrhicle

Greetings
Post #1569454
Posted Monday, May 9, 2016 1:23 PM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:29 AM
Points: 8,090, Visits: 810
Thanks for the script.
Post #1784505
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse