SQL CREATE ALTER DROP TABLE: Difference between revisions
Jump to navigation
Jump to search
(→CREATE) |
(→ALTER) |
||
(11 intermediate revisions by the same user not shown) | |||
Line 6: | Line 6: | ||
<syntaxhighlight lang='sql'> | <syntaxhighlight lang='sql'> | ||
CREATE TABLE person | CREATE TABLE person | ||
(id | ( id smallint, | ||
name varchar(30), | |||
CONSTRAINT pk_person PRIMARY KEY (id) | |||
); | ); | ||
</syntaxhighlight> | </syntaxhighlight> | ||
:{| class="wikitable" style="text-align: left;" | :{| class="wikitable" style="text-align: left;" | ||
|- | |- | ||
| PostgreSQL || | | [[PostgreSQL_DDL_Operations#Create_a_Table|PostgreSQL]] || [[MySQL_DDL_Operations#Create_Table|MySQL]] | ||
|- | |||
|} | |||
=<tt>ALTER</tt>= | |||
<syntaxhighlight lang='sql'> | |||
ALTER TABLE person [...] | |||
</syntaxhighlight> | |||
:{| class="wikitable" style="text-align: left;" | |||
|- | |||
| [[PostgreSQL_DDL_Operations#Alter_a_Table|PostgreSQL]] || [[MySQL_DDL_Operations#Alter_Table|MySQL]] | |||
|- | |||
|} | |||
=<tt>DROP</tt>= | |||
<syntaxhighlight lang='sql'> | |||
DROP TABLE person [...] | |||
</syntaxhighlight> | |||
:{| class="wikitable" style="text-align: left;" | |||
|- | |||
| [[PostgreSQL_DDL_Operations#Drop_a_Table|PostgreSQL]] || [[MySQL_DDL_Operations#Drop_Table|MySQL]] | |||
|- | |- | ||
|} | |} |
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 [...]