Tables [dbo].[DHDUserGridSettings]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:57:20 AM Thursday, March 21, 2019
Last Modified1:02:02 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsDefault
UserIDint4
False
ShowMyTicketsOnlybit1
False
FilteredQueueNamesnvarchar(200)400
False
SortFieldsnvarchar(200)400
False
SortDirectionsnvarchar(200)400
False
Groupsnvarchar(200)400
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
CREATE TABLE [dbo].[DHDUserGridSettings]
(
[UserID] [int] NOT NULL,
[ShowMyTicketsOnly] [bit] NOT NULL,
[FilteredQueueNames] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SortFields] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SortDirections] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Groups] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_DHDUserGridSettings_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_DHDUserGridSettings_LastUpdate] DEFAULT (getdate())
) ON [PRIMARY]
GO