Please Update me that, What is SCHEMA in SQL

Question

Hi Friends, Please Update me that, What is SCHEMA in SQL. Thanks...

Senthilkumar · 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

Manikandan Chandran · Answer

Thank you both very much

Jignesh Trivedi · Answer

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.

Please Update me that, What is SCHEMA in SQL

Answers (3)