Perintah Membuat Tabel

Perintah Membuat Tabel

use contoh_nim 
create table MHS1

(Nim char(10) NOT NULL,

Nama varchar (10) not null,

Alamat varchar (40) NULL,

Telepon Varchar (15),
primary key (nim));

DESC nama_tabel;
Atau
DESCRIBE nama_tabel;

Atau
SHOW COLUMNS FROM namatabel; 

DROP TABLE nama_tabel; 

Sintaks :

create table Pengajar
(NIP char(10) NOT NULL,
Nama varchar (20) not null,

Tgllhr date null,

Tmplhr varchar (20),

Alamat varchar (30),

Kota varchar (15),

primary key (NIP)); 

create table Matakuliah
(KdMk Varchar(10) NOT NULL,

Nama_MK Varchar (20) not null,

SKS char (1),

primary key (KdMk)); 

create table Kuliah
(NIP Char(10) NOT NULL,

KdMk Varchar (10) not null,

Ruang Varchar (3),

Jml_Mhs Int (4),

Primary Key (NIP,KdMk),


pengajar (nip),

Foreign Key (kdmk) references

matakuliah (kdmk);