SQL Command Syntax

This section provides a detailed reference to each of the SQL commands likely to be used by the DBA. Each command is listed in one or more of its forms, with the exact syntax of the command and its associated parameters, a short explanation of the purpose of the command, an example, and usage notes where applicable.

Note

Many statements allow you to specify a schema name. For example, if you specify:

CREATE TABLE schema.table_name

the table is created in the specified schema. If you simply specify:

CREATE TABLE table_name

the table is created in the schema of the user executing the command.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset