Computer Science, asked by TbiaSamishta, 1 year ago

List the objects available in Base.

Answers

Answered by Saifßàã
1
HLO FRIEND ^_^

Database Object

Definition - What does Database Objectmean?

A database object in a relational database is a data structure used to either store or reference data. The most common object that 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 is being created is instances of the objects, such as a new table, an index on that table or a view on the same table.

Techopedia explains Database Object

Two small but important distinctions in database objects are needed:

An object type is the base concept or idea of an object; for example, the concept of a table or index.An object instance is an example of an object type. For example, a table called CUSTOMER_MASTER is an instance of the object type TABLE.

Most of the major database engines offer the same set of major database object types:
Tables Indexes Sequences Views Synonyms


Answered by aqibkincsem
1

It is more useful to have listing of all main object in the part of the data base and here are list of the objects such as the table or queries and


it obtains using the query that uses as it source a hidden system table names and basic query and SQL statement in a fine manner.

Similar questions