CREATE, ALTER, AND DROP DATABASE IN SQL SERVER

In this article, we will discuss how to Create, Alter, and Drop a database in SQL Server.
In my previous article, we have discussed all about the Types of SQL Commands.

Database Introduction

 Database  : In the SQL server a database is a place to store the data in an electronic format. It is an organized collection of database objects such as tables, views, functions, stored procedures, triggers and so on.
It allows a user to easily access or manipulate the data.

SQL server database

Create Database In SQL Server

In SQL Server, there are two ways to create a user-defined database, either by using the Transact-SQL statements or by using SQL Server Management Studio.

Read more >>

5 Types of SQL Commands: DDL, DML, DCL, TCL, and DQL Commands

In this article, we’ll go through how to create a database in SQL Server and try and understand the different types of SQL commands. The SQL programming language supports a number of commands to perform different operations such as DCL, TCL, DQL, DDL, and DML Command.

Among other things, SQL commands can be used to create a database, create tables, add data to tables, drop tables, Alter tables, and provide access to users.

image-types of SQL Commands
Types of SQL Commands

Read more >>