Tables [dbo].[MoversConnectPoller]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count (~)5
Created10:34:27 AM Monday, March 30, 2015
Last Modified4:03:30 PM Tuesday, May 26, 2015
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Primary Key PK_MoversConnectPoller: MoversConnectPollerIDMoversConnectPollerIDint4
No
1 - 1
Indexes IX_MoversConnectPoller: IdentifierIdentifiervarchar(5)5
No
Descriptionvarchar(64)64
No
AssemblyNamevarchar(64)64
No
ClassNamevarchar(64)64
No
Activebit1
No
QueuePermissionedbit1
Yes
Indexes Indexes
NameColumnsUnique
Primary Key PK_MoversConnectPoller: MoversConnectPollerIDPK_MoversConnectPollerMoversConnectPollerID
Yes
IX_MoversConnectPollerIdentifier
Yes
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[MoversConnectPoller]
(
[MoversConnectPollerID] [int] NOT NULL IDENTITY(1, 1),
[Identifier] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AssemblyName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ClassName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Active] [bit] NOT NULL,
[QueuePermissioned] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoversConnectPoller] ADD CONSTRAINT [PK_MoversConnectPoller] PRIMARY KEY NONCLUSTERED  ([MoversConnectPollerID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoversConnectPoller] ADD CONSTRAINT [IX_MoversConnectPoller] UNIQUE NONCLUSTERED  ([Identifier]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[MoversConnectPoller] TO [MssExec]
GRANT INSERT ON  [dbo].[MoversConnectPoller] TO [MssExec]
GRANT DELETE ON  [dbo].[MoversConnectPoller] TO [MssExec]
GRANT UPDATE ON  [dbo].[MoversConnectPoller] TO [MssExec]
GO
Uses
Used By