if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FileStore]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[FileStore] GO CREATE TABLE [dbo].[FileStore] ( [FileId] [int] IDENTITY (1, 1) NOT NULL , [FileName] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [ImageData] [image] NOT NULL, [FileType] [varchar](10) NOT NULL, [Added On] [DateTime] NOT NULL, ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO