{"id":14,"date":"2011-06-27T07:54:53","date_gmt":"2011-06-27T07:54:53","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/06\/27\/ddl-data-definition-language\/"},"modified":"2011-06-27T07:54:53","modified_gmt":"2011-06-27T07:54:53","slug":"ddl-data-definition-language","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/06\/27\/ddl-data-definition-language\/","title":{"rendered":"DDL &#8211; Data Definition Language &#8211; SQL SERVER"},"content":{"rendered":"<p><strong>DDL<\/strong>:\u00a0 <em>Data Definition Language<\/em><\/p>\n<p>DDL is used to create modify and delete the Objects in the database.<\/p>\n<p>Some of the DDL Statements include <em>CREATE, ALTER, TRUNCATE, DROP<\/em>.<\/p>\n<p>DDL Statements take effect immedietly. i.e. When a ddl statement is executed its results can be seen immedietly. Hence while executing the DDL Statements the users have to be cautious of the results of the operation.<\/p>\n<p>What can DDL Statements Do?<\/p>\n<p>Following are the tasks that can be performed using DDL Statements:<\/p>\n<ul>\n<li>Create Database<\/li>\n<li>Alter Database<\/li>\n<li>Drop Database<\/li>\n<li>Create Table<\/li>\n<li>Modify Table<\/li>\n<li>Drop Table<\/li>\n<li>Truncate Table<\/li>\n<li>Create Index<\/li>\n<li>Alter\u00a0Index<\/li>\n<li>Drop Index<\/li>\n<li>Create Procedure<\/li>\n<li>Alter Procedure<\/li>\n<li>Drop Procedure<\/li>\n<li>Create Function<\/li>\n<li>Alter Function<\/li>\n<li>Drop Function<\/li>\n<li>Create Trigger<\/li>\n<li>Alter Trigger<\/li>\n<li>Drop Trigger<\/li>\n<\/ul>\n<p>For further information on the DDL Statements please click on the relevent links shown below:<\/p>\n<p>Databases, Tables, Indexes, Triggers, Functions, Procedures<\/p>\n<p>Advanced DDL Statements:<\/p>\n<p>Following are the Advanced DDL Statements in SQL Server:<\/p>\n<ul>\n<li>FULLTEXT CATALOG<\/li>\n<li>CREATE FULLTEXT CATALOG<\/li>\n<li>DROP FULLTEXT CATALOG<\/li>\n<li>CREATE FULLTEXT INDEX<\/li>\n<li>ALTER FULLTEXT INDEX<\/li>\n<li>DROP FULLTEXT INDEX<\/li>\n<li>CREATE APPLICATION ROLE<\/li>\n<li>ALTER APPLICATION ROLE<\/li>\n<li>DROP APPLICATION ROLE<\/li>\n<li>CREATE CERTIFICATE<\/li>\n<li>ALTER CERTIFICATE<\/li>\n<li>DROP CERTIFICATE<\/li>\n<li>CREATE LOGIN<\/li>\n<li>ALTER LOGIN<\/li>\n<li>DROP LOGIN<\/li>\n<li>CREATE ROLE<\/li>\n<li>ALTER ROLE<\/li>\n<li>DROP ROLE<\/li>\n<li>CREATE SCHEMA<\/li>\n<li>ALTER SCHEMA<\/li>\n<li>ALTER SCHEMA<\/li>\n<li>CREATE USER<\/li>\n<li>ALTER USER<\/li>\n<li>DROP USER<\/li>\n<li>CREATE CONTRACT<\/li>\n<li>DROP CONTRACT<\/li>\n<li>ALTER MESSAGE TYPE<\/li>\n<li>CREATE MESSAGE TYPE<\/li>\n<li>DROP MESSAGE TYPE<\/li>\n<li>ALTER QUEUE<\/li>\n<li>CREATE QUEUE<\/li>\n<li>DROP QUEUE<\/li>\n<li>ALTER REMOTE SERVICE BINDING<\/li>\n<li>CREATE REMOTE SERVICE BINDING<\/li>\n<li>DROP REMOTE SERVICE BINDING<\/li>\n<li>ALTER ROUTE<\/li>\n<li>CREATE ROUTE<\/li>\n<li>DROP ROUTE<\/li>\n<li>ALTER SERVICE<\/li>\n<li>CREATE SERVICE<\/li>\n<li>DROP SERVICE<\/li>\n<li>CREATE SYNONYM<\/li>\n<li>DROP SYNONYM<\/li>\n<li>CREATE PARTITION FUNCTION<\/li>\n<li>ALTER PARTITION FUNCTION<\/li>\n<li>DROP PARTITION FUNCTION<\/li>\n<li>CREATE PARTITION SCHEME<\/li>\n<li>ALTER PARTITION SCHEME<\/li>\n<li>DROP PARTITION SCHEME<\/li>\n<li>CREATE EVENT NOTIFICATION<\/li>\n<li>DROP EVENT NOTIFICATION<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DDL:\u00a0 Data Definition Language DDL is used to create modify and delete the Objects in the database. Some of the DDL Statements include CREATE, ALTER, TRUNCATE, DROP. DDL Statements take effect immedietly. i.e. When a ddl statement is executed its results can be seen immedietly. Hence while executing the DDL Statements the users have to&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,3],"tags":[48,49,50,51,52,53],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/14"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=14"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/14\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=14"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=14"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}