SQL CREATE ALTER DROP TABLE: Difference between revisions
Jump to navigation
Jump to search
(→CREATE) |
(→CREATE) |
||
Line 6: | Line 6: | ||
<syntaxhighlight lang='sql'> | <syntaxhighlight lang='sql'> | ||
CREATE TABLE person | CREATE TABLE person | ||
( id SMALLINT, | |||
name VARCHAR(30), | name VARCHAR(30), | ||
CONSTRAINT pk_person PRIMARY KEY (id) | CONSTRAINT pk_person PRIMARY KEY (id) | ||
); | |||
</syntaxhighlight> | </syntaxhighlight> | ||
:{| class="wikitable" style="text-align: left;" | :{| class="wikitable" style="text-align: left;" |
Revision as of 22:25, 22 May 2024
Internal
CREATE
CREATE TABLE person
( id SMALLINT,
name VARCHAR(30),
CONSTRAINT pk_person PRIMARY KEY (id)
);
PostgreSQL MariaDB