Wednesday , August 21 2019

Tag Archives: DDL

SQL Server: 06 – ALTER and DROP Statement

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 »

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 »