Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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.71 seconds. Powered By: Snitz Forums 2000