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

    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 108
    Comment on it

    SQL is Structure Query Language which is developed by E.F.Codd.Today almost all Relational Database Management Systems (RDBMS) uses SQL as the standard database language. We can use it to do different types of operations in RDBMS.

    SQL COMMAND

    SQL provides following data languages to do manipulation in RDBMS.

    DDL - Data Definition Language:

    CommandsDescription
    CreateThis command creates a new table, a view of a table, or other objects in database
    AlterThis command modifies an existing database object, such as a table.
    DropThis command deletes an entire table, a view of a table or other objects in the database.

    DML - Data Manipulation Language:

    CommandsDescription
    SelectThis command retrieves records from one or more tables
    InsertThis command insert the data into one or more tables
    UpdateThis command modify or update the records of a table in database.
    DeleteThis command deletes entire or selected records from the table in the database.

    DCL - Data Control Language:

    CommandsDescription
    Grantit gives a privilege to user in database
    RevokeThis command takes back privileges granted from user in database.

 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: