SYST10199 Lecture Notes - Lecture 15: Data Manipulation Language, Data Control Language, Data Definition Language

• School: Sheridan College
• Department: Computer Programmer
• Course: SYST10199
• Professor: Davoudpour

Document Summary

Sql 3 categories: ddl(data definition language), dml(data manipulation language), Ddl-create objects in the database, alter the structure of the database, drop objects from the database, comment on stuff to add it to the data directory, rename an object, truncate all records from a table. Dml-data manipulation language-used for managing data within schema objects; you can select data from a table, insert data into a table, update existing data within a table, delete records from a table and the space for the records remain, Dcl-control the data, grant user access privileges, revoke access privileges given within the grant command. Sql is not case sensitive, numeric values cannot be enclosed in quotes. Ddl-standard subset of sql that defines tables in a database structure, create. Database, create table, drop table, alter table among others. Show databases;//display a list of currently existing databases on the server.