SQL CREATE ALTER DROP TABLE: Difference between revisions
Jump to navigation
Jump to search
(→CREATE) |
(→CREATE) |
||
| Line 6: | Line 6: | ||
<syntaxhighlight lang='sql'> | <syntaxhighlight lang='sql'> | ||
CREATE TABLE person | CREATE TABLE person | ||
( id | ( id smallint, | ||
name | name varchar(30), | ||
CONSTRAINT pk_person PRIMARY KEY (id) | CONSTRAINT pk_person PRIMARY KEY (id) | ||
); | ); | ||
Revision as of 22:27, 22 May 2024
Internal
CREATE
CREATE TABLE person
( id smallint,
name varchar(30),
CONSTRAINT pk_person PRIMARY KEY (id)
);
PostgreSQL MariaDB
- Refactor PostgreSQL DDL Operations and surface in "Standard SQL" everything that can be handled with standard SQL.
- Refactor MySQL DDL Operations and surface in "Standard SQL" everything that can be handled with standard SQL.