SQL CREATE ALTER DROP TABLE: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 4: Line 4:
=<tt>CREATE</tt>=
=<tt>CREATE</tt>=
<syntaxhighlight lang='sql'>
<syntaxhighlight lang='sql'>
  CREATE TABLE  
CREATE TABLE person
    (
(id SMALLINT,
    );
  name VARCHAR(30),
  CONSTRAINT pk_person PRIMARY KEY (id)
);
</syntaxhighlight>
</syntaxhighlight>
:{| class="wikitable" style="text-align: left;"
:{| class="wikitable" style="text-align: left;"

Revision as of 22:21, 22 May 2024

Internal

CREATE

CREATE TABLE person 
(id SMALLINT, 
   name VARCHAR(30), 
   CONSTRAINT pk_person PRIMARY KEY (id)
);
PostgreSQL MariaDB
Retrieved from "https://kb.novaordis.com/index.php?title=SQL_CREATE_ALTER_DROP_TABLE&oldid=110528"