Welcome to the next Post, lets now speak about the SQL Statement Categories.
SQL statements are categorized into Two Types:
a. DDL (Data Definition Language)
b. DML (Data Manipulation Language)
So, What is DDL?
All the creation and deletion statements of SQL to create Tables and to Delete them are categorized as DDL. DDL also tells us about the key values and specific links between Tables.
Some of the DDL statements can be CREATE DATABASE, ALTER DATABASE, CREATE TABLE, DROP TABLE, ALTER TABLE, etc
And, what is DML?
All the queries and update statements of SQL related to Tables are categorized to be DML.
Some of the DML Statements are, SELECT, DELETE, INSERT, etc
NOTE: I will be using Uppercase for all the SQL Statements, well this doesn't mean SQL statements has to be in Upper Case, Its the standard way of writing SQL Queries and Statements. And this also helps to differentiate the General text from the SQL Statements.
Well thats all for this post, Hope you have enjoyed it. Don't Forget to check my next post.
Thank You!
SQL statements are categorized into Two Types:
a. DDL (Data Definition Language)
b. DML (Data Manipulation Language)
So, What is DDL?
All the creation and deletion statements of SQL to create Tables and to Delete them are categorized as DDL. DDL also tells us about the key values and specific links between Tables.
Some of the DDL statements can be CREATE DATABASE, ALTER DATABASE, CREATE TABLE, DROP TABLE, ALTER TABLE, etc
And, what is DML?
All the queries and update statements of SQL related to Tables are categorized to be DML.
Some of the DML Statements are, SELECT, DELETE, INSERT, etc
NOTE: I will be using Uppercase for all the SQL Statements, well this doesn't mean SQL statements has to be in Upper Case, Its the standard way of writing SQL Queries and Statements. And this also helps to differentiate the General text from the SQL Statements.
Well thats all for this post, Hope you have enjoyed it. Don't Forget to check my next post.
Thank You!
0 comments:
Post a Comment