Создание БД и таблиц

CREATE DATABASE [Delivery]
 
CREATE TABLE [Products]
(Product_code INTEGER NOT NULL UNIQUE CHECK(Product_code<10000),
Product_name CHAR(8) PRIMARY KEY,
Product_price MONEY NOT NULL CHECK(Product_price<1001));
 
CREATE TABLE [Customs]
(Custom_order_code INTEGER PRIMARY KEY CHECK(Custom_order_code<1000000),
Custom_name CHAR(10) NOT NULL,
Custom_address CHAR(30),
Custom_telephone CHAR(6),
Custom_contract_number INTEGER NOT NULL CHECK(Custom_contract_number<10000),
Custom_contract_date DATE NOT NULL DEFAULT GETDATE(),
Custom_product_name CHAR(8) NOT NULL FOREIGN KEY REFERENCES [Products](Product_name),
Custom_product_amount INTEGER NOT NULL CHECK(Custom_product_amount<10000));
 
CREATE TABLE [Shipments]
(Ship_code INTEGER CHECK(Ship_code<1000000),
Ship_order INTEGER NOT NULL CHECK(Ship_order<1000000) PRIMARY KEY FOREIGN KEY REFERENCES [Customs](Custom_order_code),
Ship_date DATE NOT NULL DEFAULT GETDATE(),
Ship_product INTEGER CHECK(Ship_product<10000));
 
CREATE TABLE [Test]
(Test_numb INTEGER PRIMARY KEY CHECK(Test_numb<100),
Test_name CHAR(8),
Test_gender CHAR(2) NOT NULL CHECK (Test_gender='f' OR Test_gender='m') DEFAULT 'f');
 
ALTER TABLE [Test] ADD Test_new_data INTEGER;
 
ALTER TABLE [Test] ALTER COLUMN Test_name CHAR(10) NOT NULL;
ALTER TABLE [Test] ALTER COLUMN Test_new_data CHAR(10);
ALTER TABLE [Test] ADD CONSTRAINT unq UNIQUE(Test_gender); 
 
ALTER TABLE [Test] DROP COLUMN Test_name;

CREATE DATABASE [Delivery]
GO
 
USE [Delivery]
GO
 
CREATE TABLE [Products] 
.....

CREATE DATABASE [Delivery]
GO
 
USE [Delivery]
GO
 
CREATE TABLE [Products]
(Product_code INTEGER NOT NULL UNIQUE CHECK(Product_code<10000),
Product_name CHAR(8) PRIMARY KEY,
Product_price MONEY NOT NULL CHECK(Product_price<1001));

USE [Delivery]
GO
 
/****** Object:  Table [dbo].[Products]    Script Date: 01/06/2015 14:16:07 ******/
SET ANSI_NULLS ON
GO
 
SET QUOTED_IDENTIFIER ON
GO
 
SET ANSI_PADDING ON
GO
 
CREATE TABLE [dbo].[Products](
    [Product_code] [INT] NOT NULL,
    [Product_name] [CHAR](8) NOT NULL,
    [Product_price] [money] NOT NULL,
PRIMARY KEY CLUSTERED 
(
    [Product_name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED 
(
    [Product_code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
 
GO
 
SET ANSI_PADDING OFF
GO
 
ALTER TABLE [dbo].[Products]  WITH CHECK ADD CHECK  (([Product_code]<(10000)))
GO
 
ALTER TABLE [dbo].[Products]  WITH CHECK ADD CHECK  (([Product_price]<(1001)))
GO