Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications
DBMS BCA Unit-3 Introduction - SQL SQL - Data Types DDL - Commands SQL - CREATE DATABASE SQL - SELECT DATABASE SQL - DROP DATABASE SQL - CREATE TABLE SQL - DESCRIBE Statement SQL - DROP TABLE SQL - ALTER Statement SQL - INSERT INTO Statement SQL - DELETE Statement SQL - UPDATE Statement SQL - FOREIGN KEY SQL - INSERT INTO Example


DDL - Commands

DDL refers to "Data Definition Language", a subset of SQL statements that change the structure of the database schema in some way, typically by creating, deleting, or modifying schema objects such as databases, tables, and views. Most DDL statements start with the keywords CREATE , DROP , or ALTER.

Various DDL Statements are: CREATE DATABASE, DROP DATABASE, CREATE TABLE, ALTER TABLE, DROP TABLE, TRUNCATE TABLE, RENAME, COMMENT, Etc.