Netezza Performance Server SQL functional categories
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, Netezza Performance Server 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.