What is Schema in Database?

Answer Posted / pradeep

Schema is a logical set of data. It contains tables, views,
Packages, constraints. This is treated as a whole database.
This has assigned with a unique id called as SID i.e.
System ID. Because of this ID one can create n number of
DBs on a single DB server. Obviously within the limit of
the hardware of DB server.

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Check if table exists in sql server?

620


Why are you getting errors when creating a new odbc dsn?

593


What is filestream?

562


What is difference between views and stored procedures?

516


While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

558






What is faster join or union?

602


What are the requirements to use odbc connections in php scripts?

599


What do you mean by tablesample?

642


What are the types of sql server?

521


How do I find the sql server database version?

534


What is join query?

502


How to provide values to user defined function parameters?

557


What are exact numeric data types in ms sql server?

514


explain extended properties

564


What is explicit cursors?

561