SQL statements for schema definition and administration

SQL statement	Function
CREATE SCHEMA	Creates a schema
DROP SCHEMA	Deletes an empty schema
CREATE TABLE	Creates a base table
ALTER TABLE	Alters columns, indexes and integrity constraints in a table
DROP TABLE	Deletes a base table and its indexes
CREATE VIEW	Creates a view
DROP VIEW	Deletes a view definition
GRANT	Grants table privileges or special privileges to a user
REVOKE	Revokes table privileges or special privileges from a user

Table 21: SQL statements for schema definition and administration