home | login | register | DMCA | contacts | help | donate |      

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z


my bookshelf | genres | recommend | rating of books | rating of authors | reviews | new | | collections | | | add

- advertisement



3.5. Novelty

ALTER TABLE [dbo].[tblCustomer] WITH NOCHECK ADD

CONSTRAINT [PK_tblCustomer] PRIMARY KEY CLUSTERED (

[ID]

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[tblDepartment] WITH NOCHECK ADD

CONSTRAINT [tblDepartment_IDPK] PRIMARY KEY CLUSTERED (

[ID]

) ON [PRIMARY]

GO

ALTER TABLE [dbo]. [tblEmployee] WITH NOCHECK ADD

CONSTRAINT [PK_tblEmployee] PRIMARY KEY CLUSTERED (

[ID]

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[tblInventory] WITH NOCHECK ADD

CONSTRAINT [PK_tblInventory] PRIMARY KEY CLUSTERED (

[ID]

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[tblOrder] WITH NOCHECK ADD

CONSTRAINT [PK_tblOrder] PRIMARY KEY CLUSTERED (

[ID]

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[tblOrderltem] WITH NOCHECK ADD

CONSTRAINT [PK_tblOrderItem] PRIMARY KEY CLUSTERED (

[ID]

) ON [PRIMARY]

GO

ALTER TABLE [dbo]. [tblRegion] WITH NOCHECK ADD

CONSTRAINT [PK_tblRegion] PRIMARY KEY CLUSTERED (

[ID]

) ON [PRIMARY]

GO

CREATE UNIQUE INDEX [IX_tblRegion] ON [dbo]. [tblRegion] ([State]) ON [PRIMARY]

GO

ALTER TABLE [dbo].[tblCustomer] ADD

CONSTRAINT [FK_tblCustomer_tblRegion] FOREIGN KEY ([State])

references [dbo].[tblRegion] (

[State]

) ON DELETE CASCADE ON UPDATE CASCADE

GO

ALTER TABLE [dbo].[tblEmployee] ADD

CONSTRAINT [FK_tblEmployee_tblDepartment] FOREIGN KEY ([DepartmentID])

REFERENCES [dbo].[tblDepartment] (

[ID]

) ON DELETE CASCADE ON UPDATE CASCADE

GO

ALTER TABLE [dbo]. [tblOrder] ADD

CONSTRAINT [FK_tblOrder_tblCustomer] FOREIGN KEY ( [CustomerID])

REFERENCES [dbo].[tblCustomer] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE

GO

ALTER TABLE [dbo].[tblOrderItem] ADD

CONSTRAINT [FK_tblOrderItem_tblInventory] FOREIGN KEY ([ItemID])

REFERENCES [dbo].[tblInventory] ([ID])

ON DELETE CASCADE ON UPDATE CASCADE,

constraint [FK_tblOrderItem_tblOrder] foreign key ([OrderID])

REFERENCES [dbo].[tblOrder] ([ID])

ON DELETE CASCADE ON UPDATE CASCADE

GO

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO

, , 3.6.


3.4. Novelty | Visual Basic.NET | 3.6. ,