if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].[ErrMessage]'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1) drop table [dbo].[ErrMessage]GO CREATE TABLE [dbo].[ErrMessage] ( [ErrID] [int] NOT NULL , [ErrCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [ErrModul] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ErrSubModul] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ErrMessage] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY]GO |