SQL CREATE ALTER DROP TABLE: Difference between revisions

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

Revision as of 22:25, 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=110534"