SQL CREATE ALTER DROP TABLE: Difference between revisions
Jump to navigation
Jump to search
(→ALTER) |
|||
(6 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
* [[SQL#CADT|SQL]] | * [[SQL#CADT|SQL]] | ||
* [[SQL_Data_Types#Overview|SQL Data Types]] | * [[SQL_Data_Types#Overview|SQL Data Types]] | ||
=Overview= | |||
=<tt>CREATE</tt>= | =<tt>CREATE</tt>= | ||
Line 7: | Line 8: | ||
CREATE TABLE person | CREATE TABLE person | ||
( id smallint, | ( id smallint, | ||
name varchar(30), | name varchar(30) NOT NULL, | ||
CONSTRAINT pk_person PRIMARY KEY (id) | CONSTRAINT pk_person PRIMARY KEY (id) | ||
); | ); | ||
Line 20: | Line 21: | ||
<syntaxhighlight lang='sql'> | <syntaxhighlight lang='sql'> | ||
ALTER TABLE person [...] | ALTER TABLE person [...] | ||
</syntaxhighlight> | |||
==Add/Remove a Column== | |||
<syntaxhighlight lang='sql'> | |||
ALTER TABLE person ADD COLUMN birthday DATE; | |||
</syntaxhighlight> | </syntaxhighlight> | ||
:{| class="wikitable" style="text-align: left;" | :{| class="wikitable" style="text-align: left;" | ||
|- | |- | ||
| [[PostgreSQL_DDL_Operations# | | [[PostgreSQL_DDL_Operations#Add/Remove_a_Column|PostgreSQL]] || [[MySQL_DDL_Operations#Alter_Table|MySQL]] | ||
|- | |- | ||
|} | |} | ||
Line 36: | Line 41: | ||
|- | |- | ||
|} | |} | ||
=Features= | |||
==<tt>AUTO_INCREMENT</tt>== | |||
{{Internal|SQL_AUTO_INCREMENT#Overview|<tt>AUTO_INCREMENT</tt>}} |
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 [...]