SQL CREATE ALTER DROP TABLE: Difference between revisions

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


<font color=darkkhaki>
<font color=darkkhaki>
* Refactor [[PostgreSQL_DDL_Operations#Internal|PostgreSQL DDL Operations]] and surface in "Standard SQL" everything that can be handled with standard SQL.
* Refactor [[MySQL_DDL_Operations|MySQL DDL Operations]] and surface in "Standard SQL" everything that can be handled with standard SQL.
* Refactor [[MySQL_DDL_Operations|MySQL DDL Operations]] and surface in "Standard SQL" everything that can be handled with standard SQL.
</font>
</font>

Revision as of 22:30, 22 May 2024

Internal

CREATE

CREATE TABLE person 
( id smallint, 
  name varchar(30), 
  CONSTRAINT pk_person PRIMARY KEY (id)
);
PostgreSQL MariaDB


  • Refactor MySQL DDL Operations and surface in "Standard SQL" everything that can be handled with standard SQL.

ALTER

DROP