create items talbe.sql

Delphi7数据库开发教程,包含该书21套实例

//如果表已经存在，则删除
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Items]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Items]
GO

//创建表
CREATE TABLE [dbo].[Items] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[DirectoryID] [int] NULL ,
	[FileName] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[OriginalFolder] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[CreateDate] [datetime] NULL ,
	[CreateUser] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FilePassword] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FileItem] [image] NULL ,
	[FileSize] [int] NULL ,
	[FileType] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO