可生成字段信息的建表示例

if exists (select 1
            from  sysobjects
           where  id = object_id('GIS_HIGHOIL_SCALE')
            and   type = 'U')
   drop table GIS_HIGHOIL_SCALE
go
/*==============================================================*/
/* Table: GIS_HIGHOIL_SCALE                                     */
/*==============================================================*/
CREATE TABLE GIS_HIGHOIL_SCALE (
   SALE_DATE            DATETIME             NOT NULL,
   PRO_DEPT_ID          VARCHAR(20)          NULL,
   PRO_DEPT_NAME        VARCHAR(100)         NULL,
   DEPT_ID              VARCHAR(20)          NOT NULL,
   DEPT_NAME            VARCHAR(100)         NULL,
   INV_NO               VARCHAR(20)          NOT NULL,
   INV_NAME             VARCHAR(50)          NULL,
   QTY                  FLOAT                NULL,
   QY_QTY               FLOAT                NULL,
   CPY_QTY              FLOAT                NULL,
   CONSTRAINT PK_GIS_HIGHOIL_SCALE PRIMARY KEY (SALE_DATE, DEPT_ID, INV_NO)
)
go

DECLARE @CURRENTUSER SYSNAME
SELECT @CURRENTUSER = USER_NAME()
EXECUTE SP_ADDEXTENDEDPROPERTY 'MS_Description',
   'YW-高标汽油(乙醇汽油)比例',
   'user', @CURRENTUSER, 'table', 'GIS_HIGHOIL_SCALE'
go

DECLARE @CURRENTUSER SYSNAME
SELECT @CURRENTUSER = USER_NAME()
EXECUTE SP_ADDEXTENDEDPROPERTY 'MS_Description',
   '日期',
   'user', @CURRENTUSER, 'table', 'GIS_HIGHOIL_SCALE', 'column', 'SALE_DATE'
go

DECLARE @CURRENTUSER SYSNAME
SELECT @CURRENTUSER = USER_NAME()
EXECUTE SP_ADDEXTENDEDPROPERTY 'MS_Description',
   '省公司ID',
   'user', @CURRENTUSER, 'table', 'GIS_HIGHOIL_SCALE', 'column', 'PRO_DEPT_ID'
go

DECLARE @CURRENTUSER SYSNAME
SELECT @CURRENTUSER = USER_NAME()
EXECUTE SP_ADDEXTENDEDPROPERTY 'MS_Description',
   '省公司名称',
   'user', @CURRENTUSER, 'table', 'GIS_HIGHOIL_SCALE', 'column', 'PRO_DEPT_NAME'
go

DECLARE @CURRENTUSER SYSNAME
SELECT @CURRENTUSER = USER_NAME()
EXECUTE SP_ADDEXTENDEDPROPERTY 'MS_Description',
   '营销中心ID',
   'user', @CURRENTUSER, 'table', 'GIS_HIGHOIL_SCALE', 'column', 'DEPT_ID'
go

DECLARE @CURRENTUSER SYSNAME
SELECT @CURRENTUSER = USER_NAME()
EXECUTE SP_ADDEXTENDEDPROPERTY 'MS_Description',
   '营销中心名称',
   'user', @CURRENTUSER, 'table', 'GIS_HIGHOIL_SCALE', 'column', 'DEPT_NAME'
go

DECLARE @CURRENTUSER SYSNAME
SELECT @CURRENTUSER = USER_NAME()
EXECUTE SP_ADDEXTENDEDPROPERTY 'MS_Description',
   '油品编码',
   'user', @CURRENTUSER, 'table', 'GIS_HIGHOIL_SCALE', 'column', 'INV_NO'
go

DECLARE @CURRENTUSER SYSNAME
SELECT @CURRENTUSER = USER_NAME()
EXECUTE SP_ADDEXTENDEDPROPERTY 'MS_Description',
   '油品名称',
   'user', @CURRENTUSER, 'table', 'GIS_HIGHOIL_SCALE', 'column', 'INV_NAME'
go

DECLARE @CURRENTUSER SYSNAME
SELECT @CURRENTUSER = USER_NAME()
EXECUTE SP_ADDEXTENDEDPROPERTY 'MS_Description',
   '日销量',
   'user', @CURRENTUSER, 'table', 'GIS_HIGHOIL_SCALE', 'column', 'QTY'
go

DECLARE @CURRENTUSER SYSNAME
SELECT @CURRENTUSER = USER_NAME()
EXECUTE SP_ADDEXTENDEDPROPERTY 'MS_Description',
   '汽油日总销量',
   'user', @CURRENTUSER, 'table', 'GIS_HIGHOIL_SCALE', 'column', 'QY_QTY'
go

DECLARE @CURRENTUSER SYSNAME
SELECT @CURRENTUSER = USER_NAME()
EXECUTE SP_ADDEXTENDEDPROPERTY 'MS_Description',
   '成品油日总销量',
   'user', @CURRENTUSER, 'table', 'GIS_HIGHOIL_SCALE', 'column', 'CPY_QTY'
go