Saturday, 17 August 2013

SQL Commands:

SQL Commands:
The standard SQL commands to interact with relational databases are CREATE, SELECT, INSERT, UPDATE, DELETE, and DROP. These commands can be classified into groups based on their nature:
DDL - Data Definition Language:
Command
Description
CREATE
Creates a new table, a view of a table, or other object in database
ALTER
Modifies an existing database object, such as a table.
DROP
Deletes an entire table, a view of a table or other object in the database.
DML - Data Manipulation Language:
Command
Description
INSERT
Creates a record
UPDATE
Modifies records
DELETE
Deletes records
DCL - Data Control Language:
Command
Description
GRANT
Gives a privilege to user
REVOKE
Takes back privileges granted from user
DQL - Data Query Language:
Command
Description
SELECT
Retrieves certain records from one or more tables

No comments:

Post a Comment