SQL CREATE ALTER DROP TABLE: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
(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#Alter_a_Table|PostgreSQL]] || [[MySQL_DDL_Operations#Alter_Table|MySQL]]
| [[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)
);
PostgreSQL MySQL

ALTER

ALTER TABLE person [...]

Add/Remove a Column

ALTER TABLE person ADD COLUMN birthday DATE;
PostgreSQL MySQL

DROP

DROP TABLE person [...]
PostgreSQL MySQL

Features

AUTO_INCREMENT

AUTO_INCREMENT
Retrieved from "https://kb.novaordis.com/index.php?title=SQL_CREATE_ALTER_DROP_TABLE&oldid=110656"