Pengantar Bahasa Query:Pembatasan (Pengekangan) Nilai pada Data: Difference between revisions
| Line 38: | Line 38: | ||
CREATE TABLE karyawan ( | CREATE TABLE karyawan ( | ||
nip CHAR(5) NOT NULL PRIMARY KEY, | nip CHAR(5) NOT NULL PRIMARY KEY, | ||
nama_peg CHAR(20) NOT NULL UNIQUE, | nama_peg CHAR(20) NOT NULL <span style="color:#ff0000">UNIQUE</span>, | ||
gaji INT, | gaji INT, | ||
tgl_lahir DATE, | tgl_lahir DATE, | ||