新人一枚,最近在自己研究一个小练习项目,项目用到的数据库是sqlserver2002,其中有一张表,语句如下:
CREATE TABLE [dbo].[tb_jsr](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](15) NOT NULL,
[sex] [char](2) NULL,
[age] [int] NULL,
[tel] [varchar](20) NULL,
[enable] [bit] NOT NULL,
CONSTRAINT [PK_tb_jsr] 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]
我现在用oracle数据库作为项目的数据库,请问大神们,下面的约束在oracle建表时应该如何书写sql?最好能把下面约束那块的代码给逐词分析一下,万分感谢~~~~~~~~~~~~~
CREATE TABLE [dbo].[tb_jsr](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](15) NOT NULL,
[sex] [char](2) NULL,
[age] [int] NULL,
[tel] [varchar](20) NULL,
[enable] [bit] NOT NULL,
CONSTRAINT [PK_tb_jsr] 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]
我现在用oracle数据库作为项目的数据库,请问大神们,下面的约束在oracle建表时应该如何书写sql?最好能把下面约束那块的代码给逐词分析一下,万分感谢~~~~~~~~~~~~~