How to create table in SQL Server that very simple for the beginner.
Note!
Please do not create the same name of Table in View Module of SQL Server Database
CREATE TABLE [dbo].[DATABASE_TABLE1](
[T_YEAR] [varchar](50) NULL,
[T_MONTH] [varchar](50) NULL,
[T_ACCOUNT] [varchar](50) NULL,
[T_NAME] [varchar](50) NULL,
[T_LASTNAME] [varchar](50) NULL,
[T_SALARY] [decimal](18, 2) NULL
) ON [PRIMARY]
Create command as details as above then click on "Execute"
or You can follow methods as image below
STEP-1Create command to create table
STEP-2After click on "Execute" then click right on database for refresh, you will see the table have created
STEP-3Click right at table then select design menu
STEP-4
You will see the structure of table as image below
STEP-5
Set Primary Key by click right on that field
Primary Key have created
