SQL，sql教程

SQL，sql教程

/* To create a foreign key in a new table */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 CASCADEON UPDATE CASCADE);GO

/* To create a foreign key in an existing table */ALTER TABLE Sales.TempSalesReasonADD CONSTRAINT FK_TempSales_SalesReason FOREIGN KEY (TempID)REFERENCES Sales.SalesReason (SalesReasonID)ON DELETE CASCADEON UPDATE CASCADE;GO