SQL - Objects

Data System Architecture


SQL Objects are the objects that may created in a database via the CREATE statement


Then most known objects are:


See section 5.4 Names and identifiers of the ansi specification

A name may have a space if it's enclosed.

"my table name"

Discover More
Data System Architecture
SQL - CREATE statement

CREATE is a SQL statement that defines the SQL object and therefore the schema
Data System Architecture
SQL - Schema (Metadata)

A SQL schema is two things: It'is a persistent, named collection of metadata (known as information_schema) that defines a schema a scope because a schema is part of the object identifier. A SQL Schema...
Counting Table
SQL - Table

A table is a SQL object that shows a relational data structure that stores data (whereas a query is a relation that does not store data) It seems to comes from the Abacuscounting table (abacus) in the...

Share this page:
Follow us:
Task Runner