SQL Syntax: ALTER TABLE
ALTER
TABLE table
ADD COLUMN column datatype (size)
DROP COLUMN column
SQL Syntax: COMMIT
COMMIT
WORK
SQL Syntax: CREATE INDEX
CREATE
[UNIQUE] INDEX index
ON
table (column1, column2, … )
WITH
{PRIMARY | DISALLOW NULL | IGNORE NULL}
SQL Syntax: CREATE TABLE
CREATE
TABLE table
(
column1 datatype
(size) [NOT NULL] [index1] ,
column2 datatype
(size) [NOT NULL] [index2],
… ,
CONSTRAINT pkname PRIMARY KEY (column, …),
CONSTRAINT fkname FOREIGN KEY (column)
REFERENCES existing_table (key_column)
ON DELETE CASCASDE
)
SQL Syntax: CREATE VIEW
CREATE
VIEW viewname
AS
SELECT
…
SQL Syntax: DELETE
DELETE
FROM
table
WHERE
condition
SQL Syntax: DROP
DROP
INDEX index ON
table
DROP
TABLE
DROP
VIEW
SQL Syntax: INSERT
INSERT
INTO table (column1, column2, …)
VALUES
(value1, value2, … )
INSERT
INTO newtable
(column1, column2, …)
SELECT
…
SQL Syntax: GRANT
GRANT
privilege privileges
ON
object ALL, ALTER, DELETE, INDEX,
TO
user | PUBLIC INSERT, SELECT, UPDATE
SQL Syntax: REVOKE
REVOKE
privilege privileges
ON
object ALL, ALTER, DELETE, INDEX,
FROM
user | PUBLIC INSERT, SELECT, UPDATE
SQL Syntax: ROLLBACK
SAVEPOINT
savepoint {optional}
ROLLBACK
WORK
TO savepoint
SQL Syntax: SELECT
SELECT
DISTINCT table.column {AS alias} , . . .
FROM
table/query
INNER
JOIN table/query ON T1.ColA = T2.ColB
WHERE
(condition)
GROUP
BY column
HAVING
(group condition)
ORDER
BY table.column
{
UNION, INTERSECT, EXCEPT … }
SQL Syntax: SELECT INTO
SELECT
column1, column2, …
INTO newtable
FROM
tables
WHERE
condition
SQL Syntax: UPDATE
UPDATE
TABLE table
SET column1 = value1, column2 = value2, …
WHERE condition
Source by: DBMS, Jerry Post, Copyright
© 2007
No comments:
Post a Comment