SQL NASCAR Parsing Chick
Posted - 06/03/2002 : 22:40:23
| Please forgive me for asking such a basic question, but I just started a SQL class. I would just like a bit of clarification on the following questions: "What three basic data functions are provided by SQL?" and "What are the SQL commands to carry out these functions?"
I could only find two...
1) Data Definition Language (DDL) - create, modify or delete database objects. Does not need to be saved.
2) Data Manipulation Language (DML) - insert, update, delete and view database data. Needs to be saved.
The SQL commands would be:
1) CREATE, ALTER, DROP, GRANT, REVOKE, DENY
2) INSERT, UPDATE, DELETE, SELECT
Any idea what the third on would be?