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]