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) NOT NULL,  
   CONSTRAINT pk_person PRIMARY KEY (id)
   CONSTRAINT pk_person PRIMARY KEY (id)
);
);

Revision as of 00:01, 23 May 2024

Internal

CREATE

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

ALTER

ALTER TABLE person [...]
PostgreSQL MySQL

DROP

DROP TABLE person [...]
PostgreSQL MySQL
Retrieved from "https://kb.novaordis.com/index.php?title=SQL_CREATE_ALTER_DROP_TABLE&oldid=110631"