DML/DDL Statements

Description

ALTER TABLE

Alters a table structure.

CREATE INDEX

Creates a new index

CREATE TABLE

Creates a new table

DELETE

Deletes existing data from a table

DROP INDEX

Deletes an index

DROP TABLE

Deletes a table

MERGE

Appends one result set to another result set

INSERT

Adds new data to a table

SELECT

Retrieves existing data from a table

TRANSFORM..PIVOT

Creates a cross-tab (spreadsheet-style) query

UPDATE

Modifies existing data in a table

Clause

Description

Aliases, AS, & IN

Allows giving tables or columns aliases for ease of coding or better clarity for viewing.

FROM

Specifies the tables used for the statement.

GROUP BY [HAVING]

Specifies the columns used to group rows.

IS [NOT] NULL

Specifies columns that contain (or do not contain) NULL values.

JOIN

Combines field values from more than one table into the result set.

ORDER BY

Specifies the columns on which to sort the result set.

WHERE

Specifies filter criteria to limit rows retrieved.