SQL CREATE ALTER DROP TABLE: Difference between revisions
Jump to navigation
Jump to search
(→DROP) |
(→ALTER) |
||
| Line 28: | Line 28: | ||
=<tt>DROP</tt>= | =<tt>DROP</tt>= | ||
<syntaxhighlight lang='sql'> | <syntaxhighlight lang='sql'> | ||
DROP TABLE person [...] | DROP TABLE person [...] | ||
Revision as of 22:34, 22 May 2024
Internal
CREATE
CREATE TABLE person
( id smallint,
name varchar(30),
CONSTRAINT pk_person PRIMARY KEY (id)
);
ALTER
ALTER TABLE person [...]
DROP
DROP TABLE person [...]