use master
go
if exists (select * from dbo.sysdatabases where name = 'Trade')
drop database Trade
GO
create database Trade
go
use Trade
go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[customers]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[customers]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[orders]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[orders]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[products]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[products]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sstock]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[sstock]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[suppliers]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[suppliers]
GO
CREATE TABLE [dbo].[customers] (
[CustomerID] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CompanyName] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ContactName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[Address] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[City] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[Region] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,