Please Update me that, What is SCHEMA in SQL

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-Schema statements.

There are 6 SQL-Schema Statements:

CREATE TABLE Statement -- create a new base table in the current schema
CREATE VIEW Statement -- create a new view table in the current schema
DROP TABLE Statement -- remove a base table from the current schema
DROP VIEW Statement -- remove a view table from the current schema
GRANT Statement -- grant access privileges for objects in the current schema to other users
REVOKE Statement -- revoke previously granted access privileges for objects in the current schema from other users

You can go through this url for more info

http://www.firstsql.com/tutor6.htm

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Accepted answer
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-Schema statements.
There are 6 SQL-Schema Statements:
- CREATE TABLE Statement -- create a new base table in the current schema
- CREATE VIEW Statement -- create a new view table in the current schema
- DROP TABLE Statement -- remove a base table from the current schema
- DROP VIEW Statement -- remove a view table from the current schema
- GRANT Statement -- grant access privileges for objects in the current schema to other users
- REVOKE Statement -- revoke previously granted access privileges for objects in the current schema from other users
You can go through this url for more info
http://www.firstsql.com/tutor6.htm
0
Manikandan Chandran14y ago
Thank you both very much
0
Jignesh Trivedi14y ago
hi,

Schema in sql means Defination of table, view, sps etc...(SQL Object)

for example when I write create statement for table that means it create schema for table.

hope this answer of your quetion.
0