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
Read More »Tag Archives: DDL
SQL Server: 05 – CREATE Statement
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 ) );
Read More »SQL Server: 04 – T-SQL Statemetns Categories
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 …
Read More »