Sql Server Create Database and Table

Sql Server Create Database – How to create a SQL Server database using tools from Microsoft is Microsoft SQL Server Management Studio. Software can be downloaded at www.microsoft.com/en-us/download/details.aspx?id=8961 On this Article, I make a Visual C # tutorial displaying the MSSQL database and display it in the DataGrid, we postpone it because the database does not yet exist. So it would be better for us to follow this tutorial in terms of Sql Server Create Database. The results of this tutorial can be used later for our purposes in creating database-based applications both desktop and mobile in the next tutorials that I will make. Therefore, please follow this tutorial as well as possible to Sql Server Create Database and Table.

Read Also :   Database Builder Online

Ok, we start the tutorial, first of all we have to do it, enter the Microsoft Management Studio by filling in the server username and password. Open the application so that the login chat screen appears as follows. Select the server Database Engine type then fill in Server name: NAME-PC\SQLEXPRESS like the model below. Then select Windows Authentication so that we do not need to enter a username + password using a Windows account. Then click Connect.

Sql Server Create Database and Table
Sql Server Create Database and Table

After that the explorer display will appear next to the connection name and folders in it. We will create a new database so we right-click the Databases folder then click New Database. Then the New Database chat will appear.

Read Also :   How To Find The PHP String Position

In the chat, fill in the Database name: Library then click OK. We will create a database called Library. Then now the explorer view in the Databases folder increases one is the Library database.

Sql Server Create Database and Table
Sql Server Create Database and Table

Sql Server Create Database and Table

After that the next step is that we will create a table in the Library database. Expand library databases (clicking the button + to the left of the Library posts in explorer) then right-click Tables New Table … Then a new tab will appear to add the columns to be built in the table. Fill in the following columns that are needed for the table we will create.

Sql Server Create Database and Table
Sql Server Create Database and Table

We will make the column id the primary key step that must be applied is right click the id column then select Primary Key Set. Then the key image will appear next to its left and the Allow Nulls column mark becomes unchecked. In addition to being set to primary key we will set this column id to be an Auto Increment column or its int value always increases. The trick is to change property Is Identity to Yes.

Now, we has Create Database and Table. thank for visit Sql Server Create Database and Table

About Admin 23 Articles
Web Programming, Database Programming

Be the first to comment

Leave a Reply

Your email address will not be published.


*