Skip to content
choisungwook edited this page May 7, 2022 · 1 revision

테이블 생성

CREATETABLEprojects (
id serialPRIMARY KEY,
name VARCHAR ( 50 ) UNIQUE NOT NULL,
description VARCHAR ( 255 ),
created_at TIMESTAMPNOT NULL,
updated_at TIMESTAMPNOT NULL
);

테이블 삭제

DROPTABLE<table이름>;

postgresql

  • DDL
  • DML
  • schemas

Clone this wiki locally