Tag Archives: DDL

ALTER Statement in SQL To add a column in a table, use the following syntax: ALTER TABLE table_name ADD column_name datatype To delete a column in a table, use the following syntax: ALTER TABLE table_name DROP COLUMN column_name  

CREATE Statement: Syntax: CREATE DATABASE database_Name; Syntax: CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) );  

  The four main categories of SQL statements are as follows: DML (Data Manipulation Language) 2. DDL (Data Definition Language) 3. DCL (Data Control Language) 4. TCL (Transaction Control Language) DML (Data Manipulation Language) DML statements affect records in a table. These are basic operations we perform on data such …