In sql below query how it is working on with detail?

Question

Any body Know Explain Below this query ? Create Table [dbo].[RegistrationEmployee]([Id] int identity(1,1) Constraint [Pk_RegistrationEmployee] primary key Clustered ( [Id] asc )with (Pad_Index=off,STATISTICS_NORECOMPUTE =off,IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]

Piyush Pansuriya · Answer

Hi, This will create new table with the name of RegistationEmployee And create one column Id with int datatype. that will be auto increment id start with 1 and seed will be 1. Also, Id column will be a Primary Key for this table.

shiva ksk · Answer

ok thanks, but what is the purpose of this below query and how its work explain detail? Constraint [Pk_RegistrationEmployee] primary key Clustered ( [Id] asc )with (Pad_Index=off,STATISTICS_NORECOMPUTE =off,IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]

Salman Beg · Answer

Hi. It is creating a table with name called as RegistrationEmployee with id as primary key and auto identity. It uses various index options and you can find details in below article, https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-index-option-transact-sql?view=sql-server-ver15

Laxmidhar Sahoo · Answer

hey you can ghet all the information from the bellow link https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-index-option-transact-sql?view=sql-server-ver15