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

      [Дата рождения] [datetime] NULL,
      [Дата смерти] [datetime] NULL,
      [Код страны] [int] NULL,
      [Место проживания] [char](100) NOT NULL,
 CONSTRAINT [PK_Авторы] PRIMARY KEY CLUSTERED
(
      [Код автора] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO

/****** Object: Index [PK_ Author_Family_Name] Script Date: 11/24/2009
15:11:07 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id =
OBJECT_ID(N'[dbo].[Авторы]') AND name = N'PK_ Author_Family_Name')
CREATE NONCLUSTERED INDEX [PK_ Author_Family_Name] ON
[dbo].[Авторы]
(
      [Фамилия автора] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
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_ Author_Deathdate]') AND parent_object_id =
OBJECT_ID(N'[dbo].[Авторы]'))
ALTER TABLE [dbo].[Авторы] WITH CHECK ADD CONSTRAINT [CK_
Author_Deathdate] 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_ Author_Family_Name]') AND parent_object_id =
OBJECT_ID(N'[dbo].[Авторы]'))
ALTER TABLE [dbo].[Авторы] WITH CHECK ADD CONSTRAINT [CK_
Author_Family_Name] CHECK (([Фамилия автора] like '[А-Яа-я ][А-Яа-я ][А-Яа-я


                                     118