SQL CREATE ALTER DROP TABLE: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
(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 SMALLINT,  
( 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;"
|-
|-
| PostgreSQL || MariaDB
| [[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)
);
PostgreSQL MySQL

ALTER

ALTER TABLE person [...]
PostgreSQL MySQL

DROP

DROP TABLE person [...]
PostgreSQL MySQL