Tables [dbo].[LookUpCtrlTypes]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:58:21 AM Thursday, March 21, 2019
Last Modified1:15:32 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Primary Key PK_LookUpCtrlTypes: TypeTypevarchar(25)25
False
SQLSelectvarchar(1750)1750
False
SQLFromvarchar(1000)1000
False
SQLWherevarchar(1000)1000
False
ColumnStringvarchar(500)500
False
Descriptionvarchar(64)64
False
('')
Foreign Keys FK_LookUpCtrlTypes_InterfaceObjectID_SHInterfaceObjects: [dbo].[SHInterfaceObjects].InterfaceObjectIDInterfaceObjectIDint4
True
BranchFiltervarchar(100)100
True
InterfaceObjectModeint4
True
LookupTypeFlagsint4
True
LookupCtrlTypeIDint4
False
1 - 1
KeyNameKey ColumnsUniqueFill Factor
Primary Key PK_LookUpCtrlTypes: TypePK_LookUpCtrlTypesType
True
80
NameColumns
FK_LookUpCtrlTypes_InterfaceObjectID_SHInterfaceObjectsInterfaceObjectID->[dbo].[SHInterfaceObjects].[InterfaceObjectID]
CREATE TABLE [dbo].[LookUpCtrlTypes]
(
[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,
[SQLWhere] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ColumnString] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_LookUpCtrlTypes_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)
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LookUpCtrlTypes] ADD CONSTRAINT [PK_LookUpCtrlTypes] PRIMARY KEY NONCLUSTERED  ([Type]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LookUpCtrlTypes] ADD CONSTRAINT [FK_LookUpCtrlTypes_InterfaceObjectID_SHInterfaceObjects] FOREIGN KEY ([InterfaceObjectID]) REFERENCES [dbo].[SHInterfaceObjects] ([InterfaceObjectID])
GO