级联外国队在2012年

问题描述：

嗨
我想设置（插入和更新规范==>删除规则==>级联）

但是Visual Studio 2012中没有这样的设置

我应该如何通过Cascade做Visual Studio 2008呢？

谢谢。

我是什么尝试过：

我与vs 2012合作，

我创建一个外键并设置（（FOREIGN KEY（[列]）REFERENCES [ToTable]（[ToTableColumn]）））。

现在我想设置删除规则和更新规则，但我不知道该怎么做。

Hi I want to set (Insert and Update specification==>delete rule==>cascade)
But there aren't such settings in Visual Studio 2012
What should I do so like Visual Studio 2008 through Cascade do?
Thanks.

What I have tried:

I work with vs 2012,
I create a foreign key and set (( FOREIGN KEY ([Column]) REFERENCES [ToTable]([ToTableColumn]) )).
Now i want to set Delete Rule and Update Rule but I do not know how to do it.

答

如果您正在寻找的脚本，请阅读：创建外键关系 [ ^ ]

以下是删除级联的示例

If its the script you're looking for, then read this: Create Foreign Key Relationships[^]

Here's an example on delete cascade

USE AdventureWorks2012;    
GO    
CREATE TABLE Sales.TempSalesReason (TempID int NOT NULL, Name nvarchar(50),     
CONSTRAINT PK_TempSales PRIMARY KEY NONCLUSTERED (TempID),     
CONSTRAINT FK_TempSales_SalesReason FOREIGN KEY (TempID)     
    REFERENCES Sales.SalesReason (SalesReasonID)     
    ON DELETE CASCADE -- <----- Look here
    ON UPDATE CASCADE    
);

级联外国队在2012年

相关推荐