3. Definition SQL

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

Organization of this chapter

• 3.1 ALTER SERVER (alter foreign server definition)

• 3.2 ALTER TABLE (alter table definition)

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

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

• 3.5 CREATE AUDIT (define audit targets)

• 3.6 CREATE FOREIGN TABLE (define a foreign table)

• 3.7 CREATE INDEX (define an index)

• 3.8 CREATE SCHEMA (define a schema)

• 3.9 CREATE SERVER (define a foreign server)

• 3.10 CREATE TABLE (define a table)

• 3.11 CREATE USER (create an HADB user)

• 3.12 CREATE VIEW (define a viewed table)

• 3.13 DROP AUDIT (delete the audit target definition)

• 3.14 DROP FOREIGN TABLE (delete a foreign table)

• 3.15 DROP INDEX (delete an index)

• 3.16 DROP SCHEMA (delete a schema)

• 3.17 DROP SERVER (delete a foreign server)

• 3.18 DROP TABLE (delete a table)

• 3.19 DROP USER (delete an HADB user)

• 3.20 DROP VIEW (delete a viewed table)

• 3.21 GRANT (grant privileges)

• 3.22 REVOKE (revoke privileges)

• 3.23 Definition SQL runtime considerations

To Page Top