SQL CREATE ALTER DROP TABLE: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 28: Line 28:


=<tt>DROP</tt>=
=<tt>DROP</tt>=
=<tt>ALTER</tt>=
<syntaxhighlight lang='sql'>
<syntaxhighlight lang='sql'>
DROP TABLE person [...]
DROP TABLE person [...]

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