Tables [dbo].[DHDUserGridColumnSettings]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:57:19 AM Thursday, March 21, 2019
Last Modified1:02:01 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsDefault
UserIDint4
False
SortOrderint4
False
ResourceIDnvarchar(25)50
False
Pinnedbit1
False
Visiblebit1
False
Widthint4
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
CREATE TABLE [dbo].[DHDUserGridColumnSettings]
(
[UserID] [int] NOT NULL,
[SortOrder] [int] NOT NULL,
[ResourceID] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Pinned] [bit] NOT NULL,
[Visible] [bit] NOT NULL,
[Width] [int] NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_DHDUserGridColumnSettings_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_DHDUserGridColumnSettings_LastUpdate] DEFAULT (getdate())
) ON [PRIMARY]
GO