Tables [dbo].[frs_stat_threshold]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:07:15 AM Wednesday, March 07, 2007
Last Modified11:09:09 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKfrs_stat_threshold: strnodename\objecttype\subtype\stattypestrnodenamevarchar(25)25
No
slotint4
Yes
lineint4
Yes
portint4
Yes
Cluster Primary Key XPKfrs_stat_threshold: strnodename\objecttype\subtype\stattypeobjecttypeint4
No
Cluster Primary Key XPKfrs_stat_threshold: strnodename\objecttype\subtype\stattypesubtypeint4
No
Cluster Primary Key XPKfrs_stat_threshold: strnodename\objecttype\subtype\stattypestattypeint4
No
numsampint4
Yes
sv1int4
Yes
sv2int4
Yes
sv3int4
Yes
sv4int4
Yes
sv5int4
Yes
sv6int4
Yes
sv7int4
Yes
sv8int4
Yes
sv9int4
Yes
sv10int4
Yes
sv11int4
Yes
sv12int4
Yes
sv13int4
Yes
sv14int4
Yes
sv15int4
Yes
sv16int4
Yes
sv17int4
Yes
sv18int4
Yes
sv19int4
Yes
sv20int4
Yes
sv21int4
Yes
sv22int4
Yes
sv23int4
Yes
sv24int4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKfrs_stat_threshold: strnodename\objecttype\subtype\stattypeXPKfrs_stat_thresholdstrnodename, objecttype, subtype, stattype
Yes
Permissions
TypeActionOwning Principal
GrantDeleteuniadmin
GrantInsertuniadmin
GrantSelectuniadmin
GrantUpdateuniadmin
GrantSelectuniuser
SQL Script
CREATE TABLE [dbo].[frs_stat_threshold]
(
[strnodename] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[slot] [int] NULL,
[line] [int] NULL,
[port] [int] NULL,
[objecttype] [int] NOT NULL,
[subtype] [int] NOT NULL,
[stattype] [int] NOT NULL,
[numsamp] [int] NULL,
[sv1] [int] NULL,
[sv2] [int] NULL,
[sv3] [int] NULL,
[sv4] [int] NULL,
[sv5] [int] NULL,
[sv6] [int] NULL,
[sv7] [int] NULL,
[sv8] [int] NULL,
[sv9] [int] NULL,
[sv10] [int] NULL,
[sv11] [int] NULL,
[sv12] [int] NULL,
[sv13] [int] NULL,
[sv14] [int] NULL,
[sv15] [int] NULL,
[sv16] [int] NULL,
[sv17] [int] NULL,
[sv18] [int] NULL,
[sv19] [int] NULL,
[sv20] [int] NULL,
[sv21] [int] NULL,
[sv22] [int] NULL,
[sv23] [int] NULL,
[sv24] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[frs_stat_threshold] ADD CONSTRAINT [XPKfrs_stat_threshold] PRIMARY KEY CLUSTERED ([strnodename], [objecttype], [subtype], [stattype]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[frs_stat_threshold] TO [uniadmin]
GRANT INSERT ON  [dbo].[frs_stat_threshold] TO [uniadmin]
GRANT DELETE ON  [dbo].[frs_stat_threshold] TO [uniadmin]
GRANT UPDATE ON  [dbo].[frs_stat_threshold] TO [uniadmin]
GRANT SELECT ON  [dbo].[frs_stat_threshold] TO [uniuser]
GO
Uses