exists (select * from sysobjects where id = object_id(N'USERS') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table USERS

GO

if exists (select * from sysobjects where id = object_id(N'CTBAOHANH') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table CTBAOHANH

GO

if exists (select * from sysobjects where id = object_id(N'BAOHANH') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table BAOHANH

GO

if exists (select * from sysobjects where id = object_id(N'CTHOADON') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table CTHOADON

GO

if exists (select * from sysobjects where id = object_id(N'HOADON') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table HOADON

GO

if exists (select * from sysobjects where id = object_id(N'KHACHHANG') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table KHACHHANG

GO

if exists (select * from sysobjects where id = object_id(N'HANGHOA') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table HANGHOA

GO

/* ============================================================ */

/* Table: USERS */

/* ============================================================ */

create table USERS

(

USERNAMES CHAR(30) NOT NULL,

PASSWORDS CHAR(30) NOT NULL,

constraint PK_USERS primary key (USERNAMES)

)

go

/* ============================================================ */

/* Table: KHACHHANG */

/* ============================================================ */

create table KHACHHANG

(

MAKH char(5) not null,

TENKH varchar(20) null ,

DIACHI varchar(50) null ,

DIENTHOAI varchar(9) null ,

FAX varchar(9) null ,

EMAIL varchar(50) null ,

constraint PK_KHACHHANG primary key (MAKH)

)

go

/* ============================================================ */

/* Table: HANGHOA */

/* ============================================================ */

create table HANGHOA

(

MAH char(4) not null,

TENH varchar(20) null ,

GIA int null ,

SOLUONG int null ,

BAOHANH varchar(10) null ,

HANGSX varchar(30) null ,

KHUYENMAI varchar(50) null ,

constraint PK_HANGHOA primary key (MAH)

)

go

/* ============================================================ */

/* Table: PHIEUXUAT *