SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Three Basic Data Functions?
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ledell
SQL NASCAR Parsing Chick

USA
107 Posts

Posted - 06/03/2002 :  22:40:23  Show Profile  Visit Ledell's Homepage
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?

bm1000
Starting Member

37 Posts

Posted - 06/04/2002 :  00:04:37  Show Profile
The third is DCL - Data Control Language. They are Grant and Revoke, (and I suppose Deny). I think that Deny is SQL Server specific.

Go to Top of Page

Ledell
SQL NASCAR Parsing Chick

USA
107 Posts

Posted - 06/04/2002 :  23:24:02  Show Profile  Visit Ledell's Homepage
Thanks for your assistance!

I know robvolk --- pity me!
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000