Übersicht der Befehle (sqlite, MySQL, Postgres, Oracle)¶

Befehl	Sqlite	MySql	Postgres	Oracle
select current_database();			x
SELECT DATABASE();		x
TABLE …
ALTER TABLE …	x	x	x	x
CREATE TABLE SQLite Postgres CREATE TABLE AS CREATE TABLE (bkzfrau)	x	x	x	x
DECLARE LOCAL TEMPORARY TABLE
DROP TABLE
SELECT Grundstruktur SELECT DISTINCT …	x	x	x	x
INSERT …	x	x	x	x
UPDATE …	x	x	x	x
T1 LEFT JOIN T2 on …	x	x	x	x
T1 RIGHT JOIN T2 on …		x	x	x
T1 FULL JOIN T2 on …		x	x	x
T1 as t1 SELF JOIN T1 as t2 on …		x	x	x
ADD
ALLOCATE CURSOR
ALTER DOMAIN
ALTER ROUTINE
ALTER SEQUENCE
GENERATOR
AETER TRANSFORM
ALTER TYPE
CALL
CLOSE
COMMIT
CONNECT
CREATE
CREATE ASSERTION
CREATE CAST
CREATE CHARACTER SET
CREATE COLLATION
CREATE DATABASE (Postgres)			x
CREATE DOMAIN
CREATE FUNCTION
CREATE INDEX (Constraints/Postgres)	x	x	x	x
CREATE METHOD
CREATE ORDERING
CREATE PROCEDURE
CREATE ROLE
CREATE SCHEMA
CREATE SEQUENCE
CREATE TRANSFORM
CREATE TRIGGER
CREATE TYPE
CREATE VIEW
DEALLOCATE DESCRIPTOR
DEALOCATE PREPARE
DECLARE
DELETE
DESCRIBE INPUT
DESCRIBE OUTPUT
DISCONNECT
DROP
DROP ASSERTATION
DROP ATTRIBUTE
DROP CAST
DROP CHARACTER SET
DROP COLLATION
DROP COLUMN
DROP CONSTRAINT
DROP DEFAULT
DROP DOMAIN
DROP METHOD
DROP ORDERING
DROP ROLE
DROP ROUTINE
DROP SCHEMA
DROP SCOPE
DROP SEQUENCE
DROP TRANSFORM
DROP TRANSLATIONION
DROP TRIGGER
DROP TYPE
DROP VIEW
EXECUTE IMMEDIATE
FETCH
FREE LOCATOR
GET DESCRIPTOR
GET DIAGNOSTICS
GRANT PRIVILEGE
GRAN ROLE
HOLD LOCATOR
INSERT
MERGE
OPEN
REPLACE
RELEASE SAVEPOINT
RETURN
REVOKE
ROLLBACK
SAVEPOINT
SELECT
SET CATALOG
SET CONNECTION
SET CONSTRAINTS
SET DESCRIPTOR
SET NAMES
SET PATH
SET SCHEMA
SET SESSION AUTHORIZATION
SET SESSION CHARACTERISTICS
SET SESSION COLLATION
seT TIME ZONE
SET TRANSACTION
SET TRANSFORM GROUP
START TRANSACTION
UPDATE