Проектирование и реализация баз данных и клиентских приложений в среде MS Visual Studio.NET. Макурин Ю.Д - 125 стр.

ALTER TABLE [dbo].[Произведения] WITH CHECK ADD CONSTRAINT
[FK_Произведения_Средства создания] FOREIGN KEY([Код средств создания])
REFERENCES [dbo].[Средства создания] ([Код средств создания])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id =
OBJECT_ID(N'[dbo].[FK_Произведения_Страны]') AND parent_object_id =
OBJECT_ID(N'[dbo].[Произведения]'))
ALTER TABLE [dbo].[Произведения] WITH CHECK ADD CONSTRAINT
[FK_Произведения_Страны] FOREIGN KEY([Код страны])
REFERENCES [dbo].[Страны] ([Код страны])
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id =
OBJECT_ID(N'[dbo].[CK_Creation_Author_Code]') AND parent_object_id =
OBJECT_ID(N'[dbo].[Произведения]'))
ALTER TABLE [dbo].[Произведения] WITH CHECK ADD CONSTRAINT
[CK_Creation_Author_Code] CHECK (((1)<=[Код автора] AND [Код автора]<=(99)))
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id =
OBJECT_ID(N'[dbo].[CK_Creation_Code]') AND parent_object_id =
OBJECT_ID(N'[dbo].[Произведения]'))
ALTER TABLE [dbo].[Произведения] WITH CHECK ADD CONSTRAINT
[CK_Creation_Code] CHECK (((1)<=[Код произведения] AND [Код
произведения]<=(99)))
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id =
OBJECT_ID(N'[dbo].[CK_Creation_Country_Code]') AND parent_object_id =
OBJECT_ID(N'[dbo].[Произведения]'))
ALTER TABLE [dbo].[Произведения] WITH CHECK ADD CONSTRAINT
[CK_Creation_Country_Code] CHECK (((1)<=[Код страны] AND [Код
страны]<=(99)))
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id =
OBJECT_ID(N'[dbo].[CK_Creation_Date]') AND parent_object_id =
OBJECT_ID(N'[dbo].[Произведения]'))
ALTER TABLE [dbo].[Произведения] WITH CHECK ADD CONSTRAINT
[CK_Creation_Date] CHECK (('01.01.1753'<=[Дата создания] AND [Дата
создания]<='01.01.2010'))
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id =
OBJECT_ID(N'[dbo].[CK_Creation_Genere_Code]') AND parent_object_id =
OBJECT_ID(N'[dbo].[Произведения]'))
ALTER TABLE [dbo].[Произведения] WITH CHECK ADD CONSTRAINT
[CK_Creation_Genere_Code] CHECK (((1)<=[Код жанра] AND [Код
жанра]<=(99)))

                                    125