Tables [dbo].[usm_cache]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count80
Created11:07:43 AM Wednesday, March 07, 2007
Last Modified1:17:01 PM Tuesday, March 30, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key XPKusm_cache: cache_idcache_idvarchar(64)64
No
use_cachetinyint1
Yes
((0))
args_criticaltinyint1
Yes
((0))
refresh_timeint4
Yes
timeoutint4
Yes
hash_keyvarchar(64)64
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKusm_cache: cache_idXPKusm_cachecache_id
Yes
Permissions
TypeActionOwning Principal
GrantDeleteusmgroup
GrantInsertusmgroup
GrantSelectusmgroup
GrantUpdateusmgroup
SQL Script
CREATE TABLE [dbo].[usm_cache]
(
[cache_id] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[use_cache] [tinyint] NULL CONSTRAINT [DF__usm_cache__use_c__2F30C763] DEFAULT ((0)),
[args_critical] [tinyint] NULL CONSTRAINT [DF__usm_cache__args___3024EB9C] DEFAULT ((0)),
[refresh_time] [int] NULL,
[timeout] [int] NULL,
[hash_key] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_cache] ADD CONSTRAINT [XPKusm_cache] PRIMARY KEY CLUSTERED ([cache_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usm_cache] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_cache] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_cache] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_cache] TO [usmgroup]
GO
Uses
Used By