Friday 7 September 2007

Types of SQL

There are three basic types of SQL:

DDL, DCL and DML.

DDL:        Data Definition Language
                Used By:                DBA
                Examples:        CREATE, ALTER, DROP

DCL:        Data Control Language
                Used By:                DBA
                Examples:        GRANT, REVOKE

DML:        Data Manipulation Language
                Used By:                USERS, DBA
                Examples:        SELECT, INSERT, UPDATE, DELETE

"Creativity can solve almost any problem. The creative act, the defeat of habit by originality, overcomes everything." - George Lois

No comments: