createtable.sql

来自「aspupload」· SQL 代码 · 共 15 行

if exists (select * from sysobjects where id = object_id(N'[dbo].[MYIMAGES]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MYIMAGES]
GO


CREATE TABLE [dbo].[MYIMAGES] (
	[id] [integer] IDENTITY,
	[image_blob] [image] NULL,
	[filename] [char] (50) NULL,
	[filesize] [numeric] NULL,
	[description] [char] (255) NULL,
	[hash] [char] (50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO