SQL CREATE ALTER DROP TABLE: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 7: Line 7:
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>

Revision as of 22:24, 22 May 2024

Internal

CREATE

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