Work with database objects

Last modified: May 28, 2025

This section describes how to manage database objects such as tables, views, keys, constraints, triggers, and stored procedures. It explains how to create, copy, modify, and delete objects, define table structures, and edit table data. Additional topics include filtering and counting objects, generating DDL and DML statements, viewing dependencies, and identifying invalid objects.

In this section

Create a database object

Create a copy of a database object

Delete a database object

Display the number of database objects

Filter database objects

Create, view, drop, and edit tables

Define table structure

Alternative table editing

Alter an existing table

View and edit table data

Unique and primary keys

Primary keys

Check constraints

Foreign keys

Work with views

Generate the DDL and DML statements for database objects

Work with stored procedures

Create a trigger

View object dependencies

Find invalid objects