DDL

CREATE

ALTER

DROP

 

스키마 

create schema A default character set utf8;

drop schema A;

 

create database B default character set utf8mb4;

drop database B;

 

create tablename();

 

not null

default

primary key

foreign key

references

unique

check

on delete/on update

 

기본키

a varchar(10) not null primary key,

= constraint a_b primary key a

외래키

constraint A_B foreign key (b) references B (b);

복합키

constraint a_b primary key (a,b)