Tips And Tricks
Archives
►
2013
(3)
►
June
(1)
►
May
(2)
►
2012
(1)
►
April
(1)
▼
2011
(27)
►
December
(2)
►
September
(4)
►
August
(1)
►
July
(2)
►
June
(3)
►
May
(7)
►
April
(1)
►
March
(3)
▼
February
(3)
Debugging an HTTP Handler (*.ashx) in ASP.NET 2.0
Modify an existing constraint
Deploying Reports
►
January
(1)
►
2010
(47)
►
December
(9)
►
November
(5)
►
October
(4)
►
September
(7)
►
August
(3)
►
July
(8)
►
June
(5)
►
May
(1)
►
April
(5)
Friday, February 4, 2011
Modify an existing constraint
Modify an existing constraint requires next steps
- drop the existing constraint
ALTER
TABLE
[dbo]
.
[tblA]
DROP
FK_
tblA_a
-adding this constraint again
ALTER
TABLE
[dbo]
.
[tblA]
WITH
CHECK
ADD
CONSTRAINT
[
FK_
tblA_a
]
FOREIGN
KEY
(
[IdCol]
)
REFERENCES
[dbo]
.
[tblB]
(
[ID]
)
ON
UPDATE
CASCADE
ON
DELETE
CASCADE
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment