DB2 - Exemplos de comandos - ALTER, CREATE, DROP, JOIN, INSERT, SELECT
Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com
DB2 - Exemplos de comandos - ALTER, CREATE, DROP, JOIN, INSERT, SELECT
ALTER
CREATE
DROP
INSERT
JOIN
SELECT
ALTER COLUMN
ALTER DATABASE
ALTER INDEX
ALTER TABLE
ALTER TABLESPACE
ALTER VIEW
CREATE
CREATE DATABSE
CREATE INDEX
CREATE/REPLACE VIEW
CREATE PROCEDURE
CREATE SYNONYM
CREATE TABLE
CREATE VIEW
DROP
DROP COLUMN
DROP CONSTRAINT
DROP DATABASE
DROP DEFAULT
DROP INDEX
DROP TABLE
DROP VIEW
INSERT com SUBQUERY
INSERT INTO
INSERT INTO SELECT
INSERT MULTIPLE ROWS
FULL OUTER JOIN
INNER JOIN
INNER JOIN - Impl. e Expl.
INNER JOIN - sinônimo
INNER JOIN - três tabelas
JOIN
LEFT JOIN
OUTER JOIN
OUTER JOIN - COALESCE
OUTER JOIN com 3 tabelas
RIGHT JOIN
SELECT
SELECT DISTINCT
SELECT fácil e difícil leitura
SELECT INTO
