SQL CREATE ALTER DROP TABLE: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 24: Line 24:
:{| 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#Update_a_Table|PostgreSQL]] || [[MySQL_DDL_Operations#Alter_Table|MySQL]]
|-
|-
|}
|}

Revision as of 00:18, 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 [...]
PostgreSQL MySQL

DROP

DROP TABLE person [...]
PostgreSQL MySQL

Features

AUTO_INCREMENT

AUTO_INCREMENT