Tables [dbo].[LookUpCtrlTypesEx]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:58:22 AM Thursday, March 21, 2019
Last Modified1:12:40 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Primary Key PK_LookUpCtrlTypesEx: TypeTypevarchar(25)25
False
SQLSelectvarchar(1750)1750
False
SQLFromvarchar(1000)1000
False
StaticBaseConstraintsvarchar(255)255
False
SelectionConstraintsvarchar(1000)1000
False
SearchCriteriavarchar(1000)1000
False
Groupingvarchar(255)255
False
ColumnStringExvarchar(2048)2048
False
Descriptionvarchar(64)64
False
('')
Foreign Keys FK_LookUpCtrlTypesEx_InterfaceObjectID_SHInterfaceObjects: [dbo].[SHInterfaceObjects].InterfaceObjectIDInterfaceObjectIDint4
True
BranchFiltervarchar(100)100
True
InterfaceObjectModeint4
True
LookupTypeFlagsint4
True
LookupCtrlTypeIDint4
False
1 - 1
HideSystemCodesbit1
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Primary Key PK_LookUpCtrlTypesEx: TypePK_LookUpCtrlTypesExType
True
80
NameColumns
FK_LookUpCtrlTypesEx_InterfaceObjectID_SHInterfaceObjectsInterfaceObjectID->[dbo].[SHInterfaceObjects].[InterfaceObjectID]
CREATE TABLE [dbo].[LookUpCtrlTypesEx]
(
[Type] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SQLSelect] [varchar] (1750) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SQLFrom] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StaticBaseConstraints] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SelectionConstraints] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SearchCriteria] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Grouping] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ColumnStringEx] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_LookUpCtrlTypesEx_Description] DEFAULT (''),
[InterfaceObjectID] [int] NULL,
[BranchFilter] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InterfaceObjectMode] [int] NULL,
[LookupTypeFlags] [int] NULL,
[LookupCtrlTypeID] [int] NOT NULL IDENTITY(1, 1),
[HideSystemCodes] [bit] NOT NULL CONSTRAINT [DF_LookUpCtrlTypesEx_HideSystemCodes] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LookUpCtrlTypesEx] ADD CONSTRAINT [PK_LookUpCtrlTypesEx] PRIMARY KEY NONCLUSTERED  ([Type]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LookUpCtrlTypesEx] ADD CONSTRAINT [FK_LookUpCtrlTypesEx_InterfaceObjectID_SHInterfaceObjects] FOREIGN KEY ([InterfaceObjectID]) REFERENCES [dbo].[SHInterfaceObjects] ([InterfaceObjectID])
GO