SQL CREATE ALTER DROP TABLE: Difference between revisions
Jump to navigation
Jump to search
(→ALTER) |
|||
Line 23: | Line 23: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
==Add/Remove a Column== | ==Add/Remove a Column== | ||
<syntaxhighlight lang='sql'> | |||
ALTER TABLE person ADD COLUMN birthday DATE; | |||
</syntaxhighlight> | |||
:{| class="wikitable" style="text-align: left;" | :{| class="wikitable" style="text-align: left;" | ||
|- | |- |
Revision as of 00:21, 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 [...]
Add/Remove a Column
ALTER TABLE person ADD COLUMN birthday DATE;
DROP
DROP TABLE person [...]