|MS SQL Server 2012 - DBA Articles|
Overview of Data Definition Language
DDL - Data Definition Language or Data Description Language is a Computer Language that helps to define and modify Data Structure in the DBMS or RDBMS or XML.
SQL uses a collection of verbs to define and modify schema and other data object in the DBMS and RDBMS.
CREATE, ALTER, DROP are core DDL SQL verbs that helps to create new data object and modify or delete exiting data object from database.
CREATE verb is used to create database, table, views, index, synonyms, users, stored procedures and triggers data objects in the Relational Database Management System.
DROP verb is used to removes an existing database objects from Relational Database Management System. By default, RDBMS is support to drop tables, views, users and databases.
ALTER verb is used to modify existing database objects in the Relational Database Management System. By default, RDBMS is support to modify tables, views and database structure.
MS SQL Server is deployed with CREATE DATABASE and DROP DATABASE verbs to create and remove User Defined Database Structure along with specify Physical I/O Device, Data File and Log File information that maintaining through Master System Database.
MS SQL Server is deployed with CREATE TABLE, ALTER TABLE and DROP TABLE verbs to create, alter and remove User Defined Database's Table Structure along with specify Column(s) Structure.
Column(s) Structure is a combination of Column Name, Data Type, Data Size and Constraints. Multiple columns must be defines with comma to separated columns that determines the left-side-right order of the columns in the Table.
MS SQL Server is support the following DDL Statements and Data Objects.
* * * * *