What Is Data Definition Language (DDL)?
Data Definition Language (DDL) comprises the SQL statements that are used to create, modify, and delete SQL-based databases and other SQL objects. DDL is used to define the properties of these objects at creation time, or to change the properties of any of these objects after they have been created. The database itself is considered just another object, and there can be many objects under or contained within the database. Some of these objects include
Tables
Views
Stored procedures
Triggers
Users
Creating a New Database
When you installed SQL Server, several databases were created automatically. One of these is the master database. The master database holds information about each database that is added to SQL ...
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
