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.
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.
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.
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
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.
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