T-SQL MS SQL SERVER MANAGEMENT STUDIO and AZURE DATA STUDIO

MS SQL SERVER (T-SQL) Basic DDL (Data Definition Language) Commands, How can we make FASTER and SIMPLE Queries?

Muhammed ÇELİK
2 min readJun 13, 2022

How to CREATE-DROP-UPDATE Database and Table and View, and then How to RENAME-ADD-DELETE Table-Table(Row)-Constraint SQL Server (T-SQL) via MS SQL Server Management Studio or Azure Data Studio?

What are the basic SQL Server DDL (data definition language) commands and simple code queries for basic operations. How can we make our database queries FASTER and SIMPLE?

sample database create query
Photo by Muhammed ÇELİK from MS SQL Server Management Studio

What are subject titles?

01. HOW TO CREATE DATABASE?
01.1 How to Create Database?
01.2 How to Create Table?
01.3 How to Insert Values Table?
01.4 How to Save Table?
01.5 How to Create View?
02. HOW TO DROP DATABASE?
02.1 How to Drop Database?
02.2 How to Drop Table and Drop Table.Column?
02.3 How to Drop View?

03. HOW TO UPDATE DATABASE?
03.1 How to Update Table?
03.2 How to Update View?

04. HOW TO RENAME?
04.1 How to Rename Table.Columns?
04.2 How to Rename Constraints?

05. HOW TO ADD-DELETE?
05.1 How to Delete Table.Row?
05.2 How to Add-Delete Constraints?

01. HOW TO CREATE DATABASE?

01.1 How to Create Database?

01.2 How to Create Table?

01.3 How to Insert Values Table?

01.4 How to Save Table?

01.5 How to Create View?

02. HOW TO DROP DATABASE?

02.1 How to Drop Database?

02.2 How to Drop Table?

02.3 How to Drop View?

03. HOW TO UPDATE DATABASE?

03.1 How to Update Table?

03.2 How to Update View?

04. HOW TO RENAME?

04.1 How to Rename Table.Columns?

04.2 How to Rename Constraints?

05. HOW TO DELETE?
05.1 How to Delete Table.Row?

05.2 How to Add-Delete Constraints?

Useful inks & Resources:

SQL Server technical documentation — SQL Server | Microsoft Docs

SQL Tutorial — Essential SQL For The Beginners

SQL Server Tutorial

--

--