What Is Schema In Sql?
Can't find what you're looking for?
Ask a Question, Get an Answer ASAP
SQL & Schema
SQL-Schema Statements provide maintenance of catalog objects for a schema -- tables, views and privileges. This subset of SQL is also called the Data Definition Language (DDL), Data manipulation language (DML) and Data Control Language (DCL).
A relational database contains a catalog that describes the various elements in the system. The catalog divides the database into sub-databases known as schemas. Within each schema are database objects -- tables, views and privileges.
The catalog itself is a set of tables with its own schema name - definition_schema. Tables in the catalog cannot be modified directly. They are modified indirectly with SQL-chema statements.
answered 1 year ago