Tables [dbo].[Keys]
Properties
PropertyValue
CollationLatin1_General_CI_AS_KS_WS
Row Count2
Created12:33:30 PM Tuesday, March 06, 2007
Last Modified12:33:30 PM Tuesday, March 06, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
MachineNamenvarchar(256)512
Yes
Cluster Primary Key PK_Keys: InstallationID\ClientInstallationIDuniqueidentifier16
No
InstanceNamenvarchar(32)64
Yes
Cluster Primary Key PK_Keys: InstallationID\ClientClientint4
No
PublicKeyimagemax
Yes
SymmetricKeyimagemax
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_Keys: InstallationID\ClientPK_KeysInstallationID, Client
Yes
Permissions
TypeActionOwning Principal
GrantDeleteRSExecRole
GrantInsertRSExecRole
GrantReferencesRSExecRole
GrantSelectRSExecRole
GrantUpdateRSExecRole
SQL Script
CREATE TABLE [dbo].[Keys]
(
[MachineName] [nvarchar] (256) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[InstallationID] [uniqueidentifier] NOT NULL,
[InstanceName] [nvarchar] (32) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Client] [int] NOT NULL,
[PublicKey] [image] NULL,
[SymmetricKey] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Keys] ADD CONSTRAINT [PK_Keys] PRIMARY KEY CLUSTERED ([InstallationID], [Client]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Keys] TO [RSExecRole]
GRANT SELECT ON  [dbo].[Keys] TO [RSExecRole]
GRANT INSERT ON  [dbo].[Keys] TO [RSExecRole]
GRANT DELETE ON  [dbo].[Keys] TO [RSExecRole]
GRANT UPDATE ON  [dbo].[Keys] TO [RSExecRole]
GO
Uses
Used By