General MySQL Oracle SQL Server

Simplest Way To Create New Databases in SQL Server

Q

What is the simplest way to create a new database in SQL Server?

✍: FYIcenter.com

A

The simplest way to create a new database is to use the "CREATE DATABASE" statement with this syntax: 

CREATE DATABASE database_name

For example, run this statement: 

CREATE DATABASE FyiCenterData
GO

A new database called "FyiCenterData" should be created in the SQL server. Of course, FyiCenterData should be empty at this moment - no tables. But it should have some other data objects automatically created by the server.

 

⇒ "USE" - Setting the Current Database in SQL Server

⇐ What Is a Database in SQL Server

⇑ Managing Databases and Physical Files in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-11-24, 1565🔥, 0💬

General MySQL Oracle SQL Server