After creating database in SQL Server Now it is time to create a table.
Create a table that stores basic information about a user that can log in to an application the followings are the columns or fields needed in that table.
|Field Name||Data Type||Description|
|userId||varchar(50)||it stores user id information, it is unique and also primary key|
|userPwd||varchar(50)||it stores user password|
|userName||varchar(50)||it stores user name|
|userPhone||varchar(50)||it stores user phone|
|userEmail||varchar(50)||it stores user Email|
|userStatus||bit||it stores user status either true or false|
There are two ways to solve this problem. It can be either graphically or through code.
Create table using GUI in SQL Server Management Studio
- Start SQL Server Management Studio
- Expand the database name codemodes
- Right click on the tables click on Table
- And fill like the following
Now set the userId as primary key: Right-click on the row and click on Set Primary key
Now save the changes and name the table as user
Create table using Query Window in SQL Server Management Studio
Now press F5 or click on Execute button
Support us by sharing this post