DDL Statements

• DDL Statements
• Files and Filegroups
• CREATE DATABASE
• ALTER DATABASE
• DROP DATABASE
• CREATE TABLE
• DISCRIBE TABLE
• ALTER TABLE
• RENAME TABLE
• TRUNCATE TABLE
• DROP TABLE

DDL Statements

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.

DDL Statement	Data Object
CREATE / ALTER / DROP	Database
CREATE / ALTER / DROP	Table
CREATE / ALTER / DROP	View
CREATE / ALTER / DROP	Index
CREATE / ALTER / DROP	Stored Procedure
CREATE / ALTER / DROP	User Defined Function
CREATE / ALTER / DROP	Stored Trigger
CREATE / DROP	Default Column Value
CREATE / DROP	Column Integrity Rule
CREATE	Database Schema

Your Comment To AUTHOR