SQL(Structure Query Language)
SQL(Structure Query Language) Topics : A. (DML) Data Manipulation Language - Non Query B. (DDL) Data Definition Language - Execute Query C. Database Clauses D. Aggregate Functions (SQL Functions) E. Database Alas F. Database Constraints G. Categories of Keys - Database management H. Joining in Database I. Database View -imp J. Store Procedure -imp K. (DCL) Data Control Language A. (DML) Data Manipulation Language - Non Query 1. SELECT 2. INSERT 3. UPDATE 4. DELETE B. (DDL) Data Definition Language - Execute Query 1. CREATE 2. ALTER - The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. - The ALTER TABLE statement is also used to add and drop various constraints on an existing table. Add Column ALTER TABLE Customers ADD Email varchar( 255 ); Drop Column ALTER TABLE Customers DROP COLUMN ...