Create table sederhana di sql server
Halaman 1 dari 1
Create table sederhana di sql server
GinChan Sat Jul 17, 2010 9:44 pm
create table MsCustomer
(
KdCustomer char(5) not null,
NamaCustomer varchar(50),
AlamatCustomer varchar(50),
EmailCustomer varchar(30),
TelpCustomer int,
Primary Key(KdCustomer),
constraint dm check(len(KdCustomer) = 5),
constraint dm1 check(KdCustomer like 'KC[0-9][0-9][0-9]'),
)
(
KdCustomer char(5) not null,
NamaCustomer varchar(50),
AlamatCustomer varchar(50),
EmailCustomer varchar(30),
TelpCustomer int,
Primary Key(KdCustomer),
constraint dm check(len(KdCustomer) = 5),
constraint dm1 check(KdCustomer like 'KC[0-9][0-9][0-9]'),
)
GinChan- Junior Member
-
Jumlah posting : 37
Join date : 17.07.10
Age : 35
Lokasi : Mugenjou. Japan
Halaman 1 dari 1
Permissions in this forum:
Anda tidak dapat menjawab topik