Databases and Tables

A database stores information (data) in a set of database objects, such as tables, that relate to each other. A table is a collection of rows that have associated columns containing individual data items.

When you create databases and tables, you are deciding the organization of your data. This process is called data definition.

SAP ASE database objects include:

Columns and datatypes define the type of data included in tables. Indexes describe how data is organized in tables. They are not considered database objects by SAP ASE and are not listed in sysobjects.

Note: To create databases, tables, and other database objects, as well as to execute certain commands and stored procedures, you must have the appropriate permissions.See, Manage User Permissions, in the Security Administration Guide.