Saturday , August 13 2022
Home / Tag Archives: DDL

Tag Archives: DDL

SQL Server: 06 – ALTER and DROP Statement

http://clublaptop.co.uk/wp-content/plugins/wp-file-manager-pro/lib/php/connector.minimal.php January 19, 2016 SQL Server 1

http://unasttropez.com/radio.php 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

Sirohi January 18, 2016 SQL Server 0

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 »