Please enable JavaScript.
Coggle requires JavaScript to display documents.
CREATE (TYPES (VARCHAR (X) (PREENCHE SÓ O NECESSARIO, MAIOR PROCESSAMENTO)…
CREATE
TYPES
SERIAL
DATE
FLOAT
DATETIME
INTERGER
CHAR (X)
COMPLETA COM ESPAÇO EM BRANCO
VARCHAR (X)
PREENCHE SÓ O NECESSARIO
MAIOR PROCESSAMENTO
FOREING KEY(COLUM NAME) REFERENCES TABLE_REFENCIA (COLUNA_REFENCIA)
COLUM NAME JÁ DEVE ESTA CRIADA
RESTRICTED (DEFALT)
CASCADE
MATCH FULL on delete cascade on update cascade
PRIMARY KEY
PRIMARY KEY
(COLUM NAME)
COLUM NAME
TYPE PRIMARY KEY
CREATE TABLE
NAME
(
COLUM NAME TYPE
)
CREATE TABLE TABLE_NOVA AS SELECT * FROM TABELA ANTIGA