Home>Article>Database> how to create sql database

how to create sql database

清浅
清浅 Original
2019-05-11 09:48:50 97588browse

sql Steps to create a new database: Log in and select the database, right-click to create a new database, enter the new database name in the pop-up interface, then change the database configuration according to your own needs and finally click OK

When using SQL Server, the first thing to do is to create a new database. So how do we create a new database in SQL Server? The editor will explain it to you in detail below.

(1) First open SQL SERVER Management Studio, enter the login name and password to log in, of course you can also choose mixed identity to log in

how to create sql database

(2 ) After entering database management, select the database, then right-click and select the new database option, as shown in the figure below

how to create sql database

(3) Next, the new database interface will pop up , enter the name of the new database, as shown in the figure below

how to create sql database

(4) Then switch to the options page, you can make some modifications to some configuration information of the database. A reminder, if you are not very familiar with it, try not to modify it.

how to create sql database

(5) Click OK to return to the database management interface. The database you created is already in the database list, as shown in the figure below

how to create sql database

(6) In addition, in addition to creating a new database graphically, you can also create a new database through the following SQL statement. However, this method is generally not recommended as it is easy to make mistakes.

how to create sql database

Related learning recommendations:mysql learning

The above is the detailed content of how to create sql database. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn