Tables [dbo].[ServerParametersInstance]
Properties
PropertyValue
CollationLatin1_General_CI_AS_KS_WS
Row Count0
Created12:33:31 PM Tuesday, March 06, 2007
Last Modified12:33:32 PM Tuesday, March 06, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_ServerParametersInstance: ServerParametersIDServerParametersIDnvarchar(32)64
No
ParentIDnvarchar(32)64
Yes
Pathnvarchar(425)850
No
CreateDatedatetime8
No
ModifiedDatedatetime8
No
Timeoutint4
No
Indexes IX_ServerParametersInstanceExpiration: ExpirationExpirationdatetime8
No
ParametersValuesimagemax
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_ServerParametersInstance: ServerParametersIDPK_ServerParametersInstanceServerParametersID
Yes
IX_ServerParametersInstanceExpirationExpiration
SQL Script
CREATE TABLE [dbo].[ServerParametersInstance]
(
[ServerParametersID] [nvarchar] (32) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[ParentID] [nvarchar] (32) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Path] [nvarchar] (425) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[CreateDate] [datetime] NOT NULL,
[ModifiedDate] [datetime] NOT NULL,
[Timeout] [int] NOT NULL,
[Expiration] [datetime] NOT NULL,
[ParametersValues] [image] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[ServerParametersInstance] ADD CONSTRAINT [PK_ServerParametersInstance] PRIMARY KEY CLUSTERED ([ServerParametersID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ServerParametersInstanceExpiration] ON [dbo].[ServerParametersInstance] ([Expiration] DESC) ON [PRIMARY]
GO
Uses
Used By