SQL statements for schema definition and administration

Schema

SQL statement	Function
CREATE SCHEMA	Create a schema
DROP SCHEMA	Delete a schema

Table 30: SQL statements for schemas

Base table

SQL statement	Function
ALTER TABLE	Modify a base table
CREATE TABLE	Create a base table
DROP TABLE	Delete a base table

Table 31: SQL statements for base tables

View

SQL statement	Function
CREATE VIEW	Create a view
DROP VIEW	Delete a view

Table 32: SQL statements for views

Privileges

SQL statement	Function
GRANT	Grant privileges
REVOKE	Revoke privileges

Table 33: SQL statements for privileges

Procedure (Stored Procedure)

SQL statement	Function
CREATE PROCEDURE	create procedure
DROP PROCEDURE	Delete a procedure

Table 34: SQL statements for procedures

User Defined Function (UDF)

SQL statement	Function
CREATE FUNCTION	Create UDF
DROP FUNCTION	Delete UDF

Table 35: SQL statements for User Defined Functions