K-Learn

SQL Create DataBase

Posted on Sunday, 05 March 2023 11:42 AM

1. Open the SQL Server Management Studio

2. Open new Query Window

3. Create a new database: To create a new database, use the CREATE DATABASE statement followed by the name of the database you want to create. 

Syntax

CREATE DATABASE databasename;

For example, the following SQL statement creates a database named "School":

CREATE DATABASE School;

OUTPUT

After Creating DataBase,

4. Confirm the database creation: After executing the SQL statement, you should see a message indicating that the database has been created. You can also verify the creation of the database by checking the list of databases available in your SQL editor.

5. Use the database: Once you have created the database, you can start using it by switching to it using the USE statement.

For example, the following SQL statement switches to the "School" database:

USE School;

OUTPUT