Запросы

if exists (sel ect * fr om dbo.sysobjects where id = object_id(N'[dbo].[FK_zakazy_TOVAR]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALT ER   TABLE [zakazy] DROP CONSTRAINT FK_zakazy_TOVAR
GO

if exists (sel ect * fr om dbo.sysobjects where id = object_id(N'[dbo].[FK_zakazy_ZAKAZCHIK]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALT ER   TABLE [zakazy] DROP CONSTRAINT FK_zakazy_ZAKAZCHIK
GO

if exists (sel ect * fr om dbo.sysobjects where id = object_id(N'[dbo].[FK_zakazy_prodavec]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALT ER   TABLE [zakazy] DROP CONSTRAINT FK_zakazy_prodavec
GO

if exists (sel ect * fr om dbo.sysobjects where id = object_id(N'[dbo].[TOVAR]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
dr op   table [TOVAR]
GO

if exists (sel ect * fr om dbo.sysobjects where id = object_id(N'[dbo].[ZAKAZCHIK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
dr op   table [ZAKAZCHIK]
GO

if exists (sel ect * fr om dbo.sysobjects where id = object_id(N'[dbo].[prodavec]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
dr op   table [prodavec]
GO

if exists (select * fr om dbo.sysobjects wh ere id = object_id(N'[dbo].[zakazy]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
dr op   table [zakazy]
GO

CRE ATE   TABLE [TOVAR] (
    [kod-tovara] [int] IDENTITY (1, 1) NOT NULL ,
    [name-tovara] [varchar] (30) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    [price-tovara] [decimal](9, 0) NOT NULL ,
    [kol-tovara] [decimal](5, 0) NOT NULL
) ON [PRIMARY]
GO

CRE ATE   TABLE [ZAKAZCHIK] (
    [kod-prod] [int] IDENTITY (1, 1) NOT NULL ,
    [fio-zakazchik] [varchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    [city-zakazchik] [varchar] (20) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    [reiting-zakazchik] [int] NOT NULL ,
    [sum-kredita] [decimal](18, 0) NOT NULL
) ON [PRIMARY]
GO

CRE ATE   TABLE [prodavec] (
    [kod-prod] [int] IDENTITY (1, 1) NOT NULL ,
    [fio-prod] [varchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    [city-prod] [varchar] (15) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    [kom-prod] [int] NOT NULL ,
    [rukov-prod] [varchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    [plan-prod] [decimal](18, 0) NOT NULL
) ON [PRIMARY]
GO

CRE ATE   TABLE [zakazy] (
    [nomer-zakaza] [int] NOT NULL ,
    [summa-zakaza] [decimal](18, 0) NOT NULL ,
    [data-zakaza] [datetime] NOT NULL ,
    [kod-prod] [int] NOT NULL ,
    [kod-zakaza] [int] NOT NULL ,
    [kod-tovara] [int] NOT NULL
) ON [PRIMARY]
GO