Monday, 11 April 2016

DDL

DDL stands for Data Definition Language:

here DDL queries Define the data. the following are the important operations done by DDL:
1. creating the database objects like tables, views, sequences, procedures etc.
2. alter the database objects .
3. dropping the database objects.
4. granting and revoking privileges and roles in the database.
5. Following are the commands used as DDL commands:
    a. CREATE
    b. DROP
    c. ALTER
    d. GRANT
    e. REVOKE
    f. ANALYSE
    g. AUDIT
    h. COMMENT
    i. ASSOCIATE STATISTICS
    j. DISASSOCIATE STATISTICS
    k. NOAUDIT
    l. PURGE
   m. RENAME
   n. TRUNCATE
   o. UNDROP

No comments:

Post a Comment