USE [db_NLSOS]GO/****** 对象: Table [dbo].[t_number] 脚本日期: 03/12/2012 11:54:16 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_number]([id] [int] IDENTITY(1,1) NOT NULL,[category] [varchar](50) NOT NULL CONSTRAINT [DF_t_number_category] DEFAULT (''),[name] [varchar](50) NOT NULL CONSTRAINT [DF_t_number_name] DEFAULT (''),[prefix] [varchar](50) NOT NULL CONSTRAINT [DF_t_number_prestring] DEFAULT (''),[suffix] [varchar](50) NOT NULL CONSTRAINT [DF_t_number_sufstring] DEFAULT (''),[current_number] [int] NOT NULL CONSTRAINT [DF_t_number_current] DEFAULT ((0)),[format] [varchar](50) NOT NULL CONSTRAINT [DF_t_number_format] DEFAULT (''),[note] [varchar](1000) NOT NULL CONSTRAINT [DF_t_number_note] DEFAULT (''), CONSTRAINT [PK_t_number] 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]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_number', @level2type=N'COLUMN',@level2name=N'id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(唯一)分类、类别(索引)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_number', @level2type=N'COLUMN',@level2name=N'category'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_number', @level2type=N'COLUMN',@level2name=N'name'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前缀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_number', @level2type=N'COLUMN',@level2name=N'prefix'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'后缀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_number', @level2type=N'COLUMN',@level2name=N'suffix'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当前编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_number', @level2type=N'COLUMN',@level2name=N'current_number'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'格式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_number', @level2type=N'COLUMN',@level2name=N'format'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_number', @level2type=N'COLUMN',@level2name=N'note'