CREATE TABLE [dbo].[ListDialogTypes]
(
[DialogType] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SQLSelect] [varchar] (1280) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SQLFrom] [varchar] (1280) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SQLFromEx] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ColumnString] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DialogTitle] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AddOn] [bit] NOT NULL CONSTRAINT [DF_ListDialogTypes_AddOn] DEFAULT ((0)),
[IsProcType] [bit] NOT NULL CONSTRAINT [DF_ListDialogTypes_IsProcType] DEFAULT ((0)),
[SecuredObjectID] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ListDialogTypes_SecuredObjectID] DEFAULT (''),
[InterfaceObjectID] [int] NULL,
[BranchFilter] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InterfaceObjectMode] [int] NULL,
[SummaryColumns] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_ListDialogTypes_SummaryColumns] DEFAULT (''),
[ColumnStringEx] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ListDialogTypes] ADD CONSTRAINT [PK_ListDialogTypes] PRIMARY KEY NONCLUSTERED ([DialogType]) ON [PRIMARY]
GO