What Is Schema In Sql?


3 Answers

faya kasfaw Profile
faya kasfaw answered
Schema is the overall structure of the database. In general shema defines the table,the fields in each table.and the relationships b/n fields and tables
Naeem Sheeraz Profile
Naeem Sheeraz answered
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.
Anonymous Profile
Anonymous answered
Schema is a collection of objects(tables, views, procedure,...)

Answer Question