ASA SQL User's Guide
Working with Database Objects
When the database is first created, the only tables in the database are the system tables. System tables hold the database schema.
This section describes how to create, alter, and delete tables. You can execute the examples in Interactive SQL, but the SQL statements are independent of the administration tool you use. When you execute queries in Interactive SQL, you can edit the values in the result set.
For more information, see Editing table values in Interactive SQL.
To make it easier for you to re-create the database schema when necessary, create command files to define the tables in your database. The command files should contain the CREATE TABLE and ALTER TABLE statements.
For more information about groups, tables, and connecting as another user, see Referring to tables owned by groups and Database object names and prefixes.
Creating tables
Altering tables
Deleting tables
Browsing the information in tables
Managing primary keys
Managing foreign keys
Working with computed columns
Copying tables or columns within/between databases
Displaying system tables