Database objects in SQL

 Introduction:

Ø Database an object is any defined objects in a database that is used to store or reference the data.

Ø Anything which can make from the CREATE command that is called

Database objects.

Ø Database objects are used to manipulate the Data.

Schema and Non-Schema Objects:

Schema objects:

Ø It’s a collection of the logical structure of data or collection of schema objects is known as Schema.

 Schema objects include,

            ·       Views

            ·       Sequences

            ·       Synonyms

            ·       Indexes

            ·       Clusters

            ·       Database links

            ·       Procedures

            ·       Packages

            ·       Stored functions

            ·       Stored Procedures

            ·       Operators

            ·       Constraints

Non Schema objects:

·       Some objects are stored in the database and can be created and manipulated with SQL but are not contained in a schema. 

Non Schema Objects includes,

·       Contexts

·       Directories

·       Parameter files

·       Rolls

·       Profiles

·       Rollback segments

·       Table spaces

·       Users

Share: