SQL Commands
SQL COMMANDS
SQL Commands to interact with relational database are
CREATE, UPDATE, DELETE, INSERT, SELECT and DROP.
1. DDL - Data Definition Language
|
COMMAND |
DESCRIPTION |
|
CREATE |
Creates a new
table. |
|
ALTER |
Modifies an
existing database object, such as table. |
|
DROP |
Deletes an entire
table. |
1
2. DML – Data Manipulating Language
|
COMMAND |
DESCRIPTION |
|
INSERT |
Creates a
record. |
|
UPDATE |
Modifies
records. |
|
DELETE |
Deletes records. |
|
COMMAND |
DESCRIPTION |
|
GRANT |
Gives a
privilege to user. |
|
REVOKE |
Takes back privileges
granted from the user. |
4. DQL – Data Query Language
|
COMMAND |
DESCRIPTION |
|
SELECT |
Retrieves
certain records from one or more tables. |