Contoh Create table

create table MsJenisPelanggan
(
KdJenisPelanggan char (5) primary key,
JenisPelanggan varchar (20) NOT NULL,
Discount varchar (3),
constraint kon1 check (KdJenisPelanggan like 'DL[0-9][0-9][0-9]' and len (KdJenisPelanggan) = 5)
)

create table MsPelanggan
(
KdPelanggan char (5) primary key,
NamaPelanggan varchar (20) not null,
AlamatPelanggan varchar (30) not null,
NoTelPelanggan varchar (10),
EmailPelanggan varchar (20),
KdJenisPelanggan char (5) references MsJenisPelanggan --on update cascade on delete cascade,
--foreign key (KdJenisPelanggan)references MsJenisPelanggan on update cascade on delete cascade,
--constraint kon2 check (KdPelanggan like 'KS[0-9][0-9][0-9]' and len (KdPelanggan) = 5)
)

create table MsBarang
(
KdBarang char (5) primary key,
NamaBarang varchar (50) not null,
QtyBarang int,
Edition varchar (10),
constraint kon3 check (KdBarang like 'UH[0-9][0-9][0-9]' and len (KdBarang) = 5)
)

create table MsKaryawan
(
KdKaryawan char (5) primary key,
NamaKaryawan varchar (20) not null,
AlamatKaryawan varchar (30) not null,
NoTelpKaryawan varchar (12),
EmailKaryawan varchar (30),
gaji numeric (10,2),
constraint kon4 check (KdKaryawan like 'KY[0-9][0-9][0-9]' and len (KdKaryawan) = 5)
)

create table TrPengirimanHeader
(
NoFaktur char (5) primary key,
Tanggal datetime not null,
KdKaryawan char (5),
KdPelanggan char (5),
foreign key (KdKaryawan) references MsKaryawan on update cascade on delete cascade,
foreign key (KdPelanggan) references MsPelanggan on update cascade on delete cascade,
constraint kon5 check (NoFaktur like 'UT[0-9][0-9][0-9]' and len (NoFaktur) =5)
)

create table TrPengirimanDetail
(
NoFaktur char (5),
KdBarang char (5),
Qty int,
primary key (NoFaktur, KdBarang),
foreign key (Nofaktur) references TrPengirimanHeader on update cascade on delete cascade,
foreign key (KdBarang) references MsBarang on update cascade on delete cascade,
)

sp_tables
drop table MsJenisPelanggan
drop table MsPelanggan
drop table MsBarang
drop table MsKaryawan
drop table TrPengirimanHeader
drop table TrPengirimanDetail