SQL CREATE ALTER DROP TABLE: Difference between revisions
Jump to navigation
Jump to search
(→ALTER) |
|||
| Line 24: | Line 24: | ||
:{| class="wikitable" style="text-align: left;" | :{| class="wikitable" style="text-align: left;" | ||
|- | |- | ||
| [[PostgreSQL_DDL_Operations# | | [[PostgreSQL_DDL_Operations#Update_a_Table|PostgreSQL]] || [[MySQL_DDL_Operations#Alter_Table|MySQL]] | ||
|- | |- | ||
|} | |} | ||
Revision as of 00:18, 23 May 2024
Internal
Overview
CREATE
CREATE TABLE person
( id smallint,
name varchar(30) NOT NULL,
CONSTRAINT pk_person PRIMARY KEY (id)
);
ALTER
ALTER TABLE person [...]
DROP
DROP TABLE person [...]