GO
The SET QUOTED_IDENTIFIER ON
GO
The SET ANSI_PADDING ON
GO
The CREATE TABLE [dbo] [iss_user] (
(user_id)/int IDENTITY (1, 1) NOT NULL,
[user_code] [varchar] (50) NULL,
[user_account] [varchar] (50) NULL,
[user_pwd] [varchar] (50) NULL,
[user_status] [int] NULL,
[user_comm] [varchar] (200), NULL,
[role_id] [int] NULL,
PRIMARY KEY CONSTRAINT [PK_iss_user_1] CLUSTERED
(
[user_id] ASC
) WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON (PRIMARY)
) ON the (PRIMARY)
GO
The SET ANSI_PADDING OFF
GO
The SET IDENTITY_INSERT [dbo] [iss_user] ON
CodePudding user response:
Look not to understand is the SQL server statement which is the primary key of the foreign key