Schema in SQL2

[\"Dritan\"]

I am a student studying in the first year of my IT graduation, although I have got very much interest in the the software development, but if I have much interested in the Database concepts , I have gone through the threads been created in this field , so I have covered the basic concepts , but I will request you to cover once again the various schemas being used in this SQL. So please reply back your post as much as you can.

[Villiers]

The SQL2 schema is the principal high-level "container" for items in a SQL2 database structure. A schema is a given its identity entity inside the database and comprise the descriptions for:Tables, are the simple associated structures , which is identified with a primary key and has a foreign key constraints as well. This also contain many other structures such as domains and views. I really apologize for my lack of knowledge.

[Dwarner]

If talked about the view in detail they are the virtual tables, these vies are created Views, which are "virtual tables" resultant from the "genuine tables" in the database, Domains, which work like comprehensive data. You can create a view as you create a table , with a simple create query , following is the syntax of creating a view :
Create View Viewname
Simply you can delete it with a drop statement.

[Ronchi]

CREATE SCHEMA MYSCHEMA AUTHORIZATION ALLEN
CREATE TABLE CITIZEN 
(NAME VARCHAR(20),
AGE INTEGER)
CREATE TABLE AREAS
(CITY VARCHAR(20),
STATE VARCHAR(20))
GRANT ALL PRIVILEGES
ON CITIZEN TO PUBLIC
GRANT SELECT
ON AREAS
TO PETER

The above example shows how to create the Schema, this is the most simplest example.The schema describes the two tables and provides certain other users authorization to control them. It does not describe any added structures, such as views or assertions.