【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,CreateTable2.sql,希望对大家有所帮助!
USE PERSONNEL_SYS1
CREATE TABLE REWARD_PUN
(RECORD_ID bigint IDENTITY (1, 1) NOT NULL ,
WORKER_ID nvarchar (15) COLLATE Chinese_PRC_CI_AS NULL ,
WORKER_NAME nvarchar (8) COLLATE Chinese_PRC_CI_AS NULL ,
RECORD_DATE datetime NULL,
RECORD_TYPE nvarchar (2) COLLATE Chinese_PRC_CI_AS NULL ,
RECORD_CONTENT nvarchar (30) COLLATE Chinese_PRC_CI_AS NULL ,
RECORD_REASON nvarchar (30) COLLATE Chinese_PRC_CI_AS NULL ,
ALLOW_UNIT nvarchar (20) COLLATE Chinese_PRC_CI_AS NULL ,
REMARK nvarchar (255) COLLATE Chinese_PRC_CI_AS NULL
)
GO