A database object in a relational database is a data structure used to either store or reference data. The most common object that most people interact with is the table. Other objects are indexes, stored procedures, sequences, views and many more.
When a database object is created, a new object type cannot be created because all the various object types created are restricted by the very nature, or source code, of the relational database model being used, such as Oracle, SQL Server or Access. What are being created are instances of the objects, such as a new table, an index on that table or a view on the same table.
Most of the major database engines offer the same set of major database object types:
- Tables
- Indexes
- Sequences
- Views
- Synonyms
Dinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular