sys_BackupHistory 构建表的SQL

SQL Code:

USE [master]

GO
/****** Object:  Table [dbo].[sys_BackupHistory]    Script Date: 03/31/2012 10:02:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sys_BackupHistory](
 [isid] [int] IDENTITY(1,1) NOT NULL,
 [DBName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 [BackupFileName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
 [BackupPath] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,
 [BackupTime] [datetime] NULL,
 CONSTRAINT [PK_sys_BackupHistory] PRIMARY KEY CLUSTERED
(
 [isid] ASC
) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

//来源:C/S框架网(www.csframework.com) QQ:1980854898