All SQL commands belong to one of the following functional
categories:
- Data Definition Language (DDL)
- Data Control Language (DCL)
- Data Manipulation Language (DML)
- Transaction Control
- Miscellaneous commands
During database initialization,
IBM® Netezza® SQL uses DDL, DCL, and DML commands to create and populate an initial
database.
- DDL creates the system databases (system and master_db) and users
(admin and public), tables, and views.
- DCL grants privileges on database objects.
- DML retrieves and places values in the database tables.