SQL CREATE ALTER DROP TABLE: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
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>=

Revision as of 00:07, 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