⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 sql.sql

📁 很久 宏观经济韩国锦湖国家交换机海关核发个回复光滑
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
USE [master]
GO
/****** 对象:  Database [UtPiowmsRFID]    脚本日期: 04/13/2007 15:33:58 ******/
IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = N'UtPiowmsRFID')
BEGIN
CREATE DATABASE [UtPiowmsRFID] ON  PRIMARY 
( NAME = N'UtPiowmsRFID', FILENAME = N'E:\Projects\SQL2005\Database\UtPiowmsRFID.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'UtPiowmsRFID_log', FILENAME = N'E:\Projects\SQL2005\Database\UtPiowmsRFID_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
END

GO
EXEC dbo.sp_dbcmptlevel @dbname=N'UtPiowmsRFID', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [UtPiowmsRFID].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [UtPiowmsRFID] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET ARITHABORT OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET AUTO_CLOSE ON 
GO
ALTER DATABASE [UtPiowmsRFID] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [UtPiowmsRFID] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [UtPiowmsRFID] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [UtPiowmsRFID] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET  DISABLE_BROKER 
GO
ALTER DATABASE [UtPiowmsRFID] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [UtPiowmsRFID] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [UtPiowmsRFID] SET  READ_WRITE 
GO
ALTER DATABASE [UtPiowmsRFID] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [UtPiowmsRFID] SET  MULTI_USER 
GO
ALTER DATABASE [UtPiowmsRFID] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [UtPiowmsRFID] SET DB_CHAINING OFF 
GO

USE [UtPiowmsRFID]
GO

IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[Transfer]') AND OBJECTPROPERTY(ID, N'ISUSERTABLE') = 1)
        DROP TABLE [Transfer]
GO

IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[Prisoner]') AND OBJECTPROPERTY(ID, N'ISUSERTABLE') = 1)
        DROP TABLE [Prisoner]
GO

IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[Police]') AND OBJECTPROPERTY(ID, N'ISUSERTABLE') = 1)
        DROP TABLE [Police]
GO

IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[Jail]') AND OBJECTPROPERTY(ID, N'ISUSERTABLE') = 1)
        DROP TABLE [Jail]
GO

IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[Device]') AND OBJECTPROPERTY(ID, N'ISUSERTABLE') = 1)
        DROP TABLE [Device]
GO

IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[RTLS]') AND OBJECTPROPERTY(ID, N'ISUSERTABLE') = 1)
        DROP TABLE [RTLS]
GO


/****** 对象:  Table [dbo].[Prisoner]    脚本日期: 04/13/2007 15:34:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Prisoner]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Prisoner](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Number] [nvarchar](50) NOT NULL,
	[WDNumber] [nvarchar](50) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[Sex] [int] NOT NULL,
	[CardType] [int] NOT NULL CONSTRAINT [DF_FRXX_ZJMC]  DEFAULT ((0)),
	[CardNum] [nvarchar](50) NOT NULL,
	[CardClass] [int] NOT NULL CONSTRAINT [DF_FRXX_SFJB]  DEFAULT ((0)),
	[State] [int] NOT NULL CONSTRAINT [DF_FRXX_JKZT]  DEFAULT ((0)),
	[InTime] [datetime] NOT NULL CONSTRAINT [DF_FRXX_RYSJ]  DEFAULT (getdate()),
	[Jail] [int] NOT NULL CONSTRAINT [DF_FRXX_SSJQ]  DEFAULT ((0)),
	[CardAddress] [nvarchar](150) NOT NULL,
	[Postal] [nvarchar](50) NOT NULL,
	[Address] [nvarchar](150) NOT NULL,
	[PostalCode] [nvarchar](50) NOT NULL,
	[Phone] [nvarchar](50) NOT NULL,
	[Power] [nvarchar](100) NOT NULL CONSTRAINT [DF_FRXX_SJQX]  DEFAULT ('0'),
	[PowerTime] [nvarchar](50) NOT NULL CONSTRAINT [DF_FRXX_YXSJ]  DEFAULT ('0,0,0,0,0,0,0'),
	[Remarks] [nvarchar](max) NULL,
	[Resume] [nvarchar](max) NULL,
	[Characteristic] [nvarchar](max) NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'ID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自动编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'ID'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'Number'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'犯人编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'Number'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'WDNumber'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'腕带编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'WDNumber'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'Name'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'Name'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'Sex'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'Sex'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'CardType'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证件名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'CardType'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'CardNum'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证件号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'CardNum'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'CardClass'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'身份级别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'CardClass'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'State'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'监控状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'State'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'InTime'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入狱时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'InTime'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'Jail'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属监区' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'Jail'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'CardAddress'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证件地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'CardAddress'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'Postal'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证件邮编' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'Postal'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'Address'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'Address'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'PostalCode'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系邮编' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'Phone'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'Phone'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'Power'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出入权限' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'Power'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'PowerTime'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'允许时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'PowerTime'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'Remarks'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'Remarks'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'Resume'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'简历' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'Resume'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Prisoner', N'COLUMN',N'Characteristic'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'特征' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Prisoner', @level2type=N'COLUMN',@level2name=N'Characteristic'
GO

/****** 对象:  Table [dbo].[Police]    脚本日期: 04/13/2007 15:34:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Police]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Police](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Number] [nvarchar](50) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[Sex] [int] NOT NULL CONSTRAINT [DF_JYXX_JYXB]  DEFAULT ((0)),
	[CardType] [int] NOT NULL CONSTRAINT [DF_JYXX_ZJMC]  DEFAULT ((0)),
	[CardNum] [nvarchar](50) NOT NULL,
	[CardAddress] [nvarchar](150) NULL,
	[Postal] [nvarchar](50) NULL,
	[Address] [nvarchar](50) NULL,
	[PostalCode] [nvarchar](50) NULL,
	[Phone] [nvarchar](50) NULL,
	[CardClass] [int] NOT NULL CONSTRAINT [DF_JYXX_RYJB]  DEFAULT ((0)),
	[InTime] [datetime] NOT NULL CONSTRAINT [DF_JYXX_DRSJ]  DEFAULT (getdate()),
	[State] [int] NOT NULL CONSTRAINT [DF_JYXX_ZZZT]  DEFAULT ((0)),
	[Remarks] [nvarchar](max) NULL,
	[Resume] [nvarchar](max) NULL,
	[Characteristic] [nvarchar](max) NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'Number'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'Number'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'Name'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'Name'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'Sex'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'Sex'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'CardType'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证件名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'CardType'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'CardNum'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证件号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'CardNum'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'CardAddress'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证件地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'CardAddress'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'Postal'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证件邮编' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'Postal'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'Phone'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'Phone'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'CardClass'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员级别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'CardClass'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'InTime'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调入时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'InTime'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'State'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'在职状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'State'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'Remarks'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'Remarks'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'Resume'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'简历' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'Resume'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Police', N'COLUMN',N'Characteristic'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'特征' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Police', @level2type=N'COLUMN',@level2name=N'Characteristic'
GO

/****** 对象:  Table [dbo].[MapInfo]    脚本日期: 04/13/2007 15:34:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MapInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[MapInfo](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Jail] [int] NOT NULL CONSTRAINT [DF_DTXX_SSJQ]  DEFAULT ((0)),
	[Name] [nvarchar](50) NOT NULL,
	[Type] [int] NOT NULL CONSTRAINT [DF_DTXX_DTLX]  DEFAULT ((0)),
	[Content] [nvarchar](max) NULL,
	[Introduce] [nvarchar](max) NULL,
	[Describe] [nvarchar](max) NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'MapInfo', N'COLUMN',N'ID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自动编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MapInfo', @level2type=N'COLUMN',@level2name=N'ID'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'MapInfo', N'COLUMN',N'Jail'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属监区ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MapInfo', @level2type=N'COLUMN',@level2name=N'Jail'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'MapInfo', N'COLUMN',N'Name'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地图名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MapInfo', @level2type=N'COLUMN',@level2name=N'Name'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'MapInfo', N'COLUMN',N'Type'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地图类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MapInfo', @level2type=N'COLUMN',@level2name=N'Type'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'MapInfo', N'COLUMN',N'Content'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地图类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MapInfo', @level2type=N'COLUMN',@level2name=N'Content'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'MapInfo', N'COLUMN',N'Introduce'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地图说明' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MapInfo', @level2type=N'COLUMN',@level2name=N'Introduce'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'MapInfo', N'COLUMN',N'Describe'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出入口描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MapInfo', @level2type=N'COLUMN',@level2name=N'Describe'
GO

/****** 对象:  Table [dbo].[Jail]    脚本日期: 04/13/2007 15:34:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Jail]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Jail](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Class] [int] NOT NULL,
	[Number] [nvarchar](50) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[Police] [int] NOT NULL,
	[Remarks] [nvarchar](max) NULL,
	[Jail] [nvarchar](50) NOT NULL,
        [JailCount] [int] NOT NULL,
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -