Tables [dbo].[ListDialogTypes]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:58:16 AM Thursday, March 21, 2019
Last Modified1:15:32 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Primary Key PK_ListDialogTypes: DialogTypeDialogTypevarchar(32)32
False
SQLSelectvarchar(1280)1280
True
SQLFromvarchar(1280)1280
True
SQLFromExvarchar(1024)1024
False
ColumnStringvarchar(1024)1024
False
DialogTitlevarchar(64)64
False
AddOnbit1
False
((0))
IsProcTypebit1
False
((0))
SecuredObjectIDvarchar(30)30
False
('')
InterfaceObjectIDint4
True
BranchFiltervarchar(100)100
True
InterfaceObjectModeint4
True
SummaryColumnsvarchar(512)512
True
('')
ColumnStringExvarchar(2048)2048
True
KeyNameKey ColumnsUniqueFill Factor
Primary Key PK_ListDialogTypes: DialogTypePK_ListDialogTypesDialogType
True
80
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