what is schema

[vedapriya]

what do u mean by schema in sql

[richardson]

IT is the definition of an entire database.
It defines the structure and the type of contents that each data element within the structure can contain.
Within each schema is database objects like tables, views and previledges.

[vedapriya]

IT is the definition of an entire database.
It defines the structure and the type of contents that each data element within the structure can contain.
Within each schema is database objects like tables, views and previledges.

can u explain more clearly

[MMcCarthy]

can u explain more clearly

schema is a way of physically displaying the database layout. As an example:

Employee {EmpID, EmpName, Address, Phone, SSN, DeptID (FK)}

This would be the schema for the table Employee. EmpID is underlined to indicate it is a Primary Key and DeptID has FK in brackets to indicate it is a foreign key.

How a schema is written can depend on various factors. This is just one example. It is a broad term referring usually to the physical design structure of the tables in a database.

[jayakrishnank]

what do u mean by schema in sql

Schema is the user which owns various database objects like table, procedures, functions, sequences etc...

[subash kadukunte]

Schema is the user which owns various database objects like table, procedures, functions, sequences etc...

All Schema can be users but all users cannot be a schema.