Working with database objects

This section provides procedures for adding database objects and setting database properties.

The SQL statements for creating, changing, and dropping database objects are called the data definition language (DDL). The definitions of the database objects form the database schema. A schema is the logical framework of the database.

To view information about procedures and triggers, see Using procedures, triggers, and batches.

To view conceptual information about database creation and design, see:


Set properties for database objects
View system objects in a database
Working with tables
Managing primary keys
Managing foreign keys
Working with computed columns
Working with temporary tables
Working with views
Working with regular views
Working with materialized views
Working with indexes