3. Definition SQL

This chapter describes the functions, rules, and specification formats of definition SQL statements.

Organization of this chapter

• 3.1 ALTER TABLE (alter table definition)

• 3.2 ALTER USER (alter an HADB user's information)

• 3.3 ALTER VIEW (re-create a viewed table)

• 3.4 CREATE AUDIT (define audit targets)

• 3.5 CREATE INDEX (define an index)

• 3.6 CREATE SCHEMA (define a schema)

• 3.7 CREATE TABLE (define a table)

• 3.8 CREATE USER (create an HADB user)

• 3.9 CREATE VIEW (define a viewed table)

• 3.10 DROP AUDIT (delete the audit target definition)

• 3.11 DROP INDEX (delete an index)

• 3.12 DROP SCHEMA (delete a schema)

• 3.13 DROP TABLE (delete a table)

• 3.14 DROP USER (delete an HADB user)

• 3.15 DROP VIEW (delete a viewed table)

• 3.16 GRANT (grant privileges)

• 3.17 REVOKE (revoke privileges)

• 3.18 Definition SQL runtime considerations

To Page Top