SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[employee]( [emp_id] [int] NOT NULL, [id_card] [varchar](18) NULL, [name] [varchar](20) NULL, [gender] [varchar](2) NULL, [birthdate] [date] NULL, [phone] [varchar](11) NULL, PRIMARY KEY CLUSTERED ( [emp_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], UNIQUE NONCLUSTERED ( [phone] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], UNIQUE NONCLUSTERED ( [id_card] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO给出上述表的数据字典
时间: 2024-04-06 11:31:03 浏览: 249
SQL_SET.rar_SetSQL_sql_sql set _sql set connectattr_sql set rouc
表名:employee
列名:
- emp_id:整数类型,非空,员工编号
- id_card:字符串类型,长度为18,可空,身份证号
- name:字符串类型,长度为20,可空,员工姓名
- gender:字符串类型,长度为2,可空,员工性别
- birthdate:日期类型,可空,员工出生日期
- phone:字符串类型,长度为11,可空,员工手机号码
约束:
- 主键约束:emp_id
- 唯一约束:phone、id_card
阅读全文