Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ledell
SQL NASCAR Parsing Chick
107 Posts |
 Posted - 2002-06-03 : 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, DENY2) INSERT, UPDATE, DELETE, SELECTAny idea what the third on would be? |
|
|
bm1000
Starting Member
37 Posts |
Posted - 2002-06-04 : 00:04:37
|
| The third is DCL - Data Control Language. They are Grant and Revoke, (and I suppose Deny). I think that Deny is SQL Server specific. |
 |
|
|
Ledell
SQL NASCAR Parsing Chick
107 Posts |
Posted - 2002-06-04 : 23:24:02
|
| Thanks for your assistance!I know robvolk --- pity me! |
|
|
|
|
|
|
Three Basic Data Functions?