建表语句：t_number

最新推荐文章于 2022-02-25 22:27:45 发布

杠杠峰

最新推荐文章于 2022-02-25 22:27:45 发布

阅读量1.2k

点赞数

本文链接：https://blog.csdn.net/lmn13/article/details/7344439

版权

USE [db_NLSOS]
GO
/****** 对象:  Table [dbo].[t_number]    脚本日期: 03/12/2012 11:54:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]

GO
SET ANSI_PADDING OFF
GO
EXEC 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'
GO
EXEC 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'
GO
EXEC 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'
GO
EXEC 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'
GO
EXEC 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'
GO
EXEC 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'
GO
EXEC 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'
GO
EXEC 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'