Tables [dbo].[AgentConnectSetup]
Properties
PropertyValue
Row Count (~)1
Created7:31:25 PM Tuesday, June 11, 2024
Last Modified7:31:28 PM Tuesday, June 11, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_AgentConnectSetup: AgentConnectSetupIDCheck Constraints CK_AgentConnectSetupID : ([AgentConnectSetupID]=(1))AgentConnectSetupIDint4
No
((1))
AgentDownloadDefaultbit1
No
((0))
AgentUploadDefaultbit1
No
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_AgentConnectSetup: AgentConnectSetupIDPK_AgentConnectSetupAgentConnectSetupID
Yes
Check Constraints Check Constraints
NameOn ColumnConstraint
CK_AgentConnectSetupIDAgentConnectSetupID([AgentConnectSetupID]=(1))
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[AgentConnectSetup]
(
[AgentConnectSetupID] [int] NOT NULL CONSTRAINT [DF_AgentConnectSetup_AgentConnectSetupID] DEFAULT ((1)),
[AgentDownloadDefault] [bit] NOT NULL CONSTRAINT [DF_AgentConnectSetup_AgentDownloadDefault] DEFAULT ((0)),
[AgentUploadDefault] [bit] NOT NULL CONSTRAINT [DF_AgentConnectSetup_AgentUploadDefault] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AgentConnectSetup] ADD CONSTRAINT [CK_AgentConnectSetupID] CHECK (([AgentConnectSetupID]=(1)))
GO
ALTER TABLE [dbo].[AgentConnectSetup] ADD CONSTRAINT [PK_AgentConnectSetup] PRIMARY KEY CLUSTERED  ([AgentConnectSetupID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[AgentConnectSetup] TO [MssExec]
GRANT INSERT ON  [dbo].[AgentConnectSetup] TO [MssExec]
GRANT DELETE ON  [dbo].[AgentConnectSetup] TO [MssExec]
GRANT UPDATE ON  [dbo].[AgentConnectSetup] TO [MssExec]
GO
Uses