Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Schemas in SQL

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 213
    Comment on it

    Schema or Structure can be defined in SQL

    A schema is a collection of logical structures of data objects. A schema is associated with a database user and has the same name as that user. Each user have a single schema. Schema is mainly collection of objects can be created and manipulated with SQL.

    In Sql if we look at the structure we first have a database for individual user and inside that database we have multiple objects means tables we can refer to the table as object

    For ex:  Select * from dbo.student
    

    dbo here is the Database Object which tells about the Schema we are using

    Schema is like a container which contain objects or elements or tables whatever you want to say. So this container is like a class and everything inside this container is like an object

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: