A database object is a component of a database used to view or manipulate data.
Object type | Description | |
---|---|---|
Column | A data value that describes one characteristic of an entity. A column contains an individual data item within a row or record. Also called a field. | |
Default | The option chosen by the system when no other option is specified. | |
Index | A database object that consists of key values from the data tables and pointers to the pages that contain those values. Indexes speed up access to data rows by pointing the data server to the location of column data on disk. | |
Procedure | A collection of SQL statements and optional control-of-flow statements stored under a name. Procedures supplied by the data server are called system procedures. | |
Rule | A specification that controls what data can be entered in a particular column or in a column of a particular user-defined datatype. | |
Table | A collection of rows that have associated columns. The logical equivalent of a database file. | |
Trigger | A special form of stored procedure that goes into effect when a user gives a change command such as insert, delete, or update to a specified table or column. Triggers are often used to enforce referential integrity. | |
View | A named select statement that is stored in the database as an object. It allows users to see a subset of rows or columns from one or more tables. |