departments.sql

来自「财务管理系统 报账等基本功能实现 有完整的实现」· SQL 代码 · 共 15 行

USE Mis
GO
CREATE TABLE [Departments] (
	[DepId] [int] NOT NULL ,
	[DepName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[UpperId] [int] NOT NULL ,
	CONSTRAINT [PK_Departments] PRIMARY KEY  CLUSTERED 
	(
		[DepId]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO