Tables [dbo].[usm_numeric_policy]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count2
Created11:07:44 AM Wednesday, March 07, 2007
Last Modified11:09:15 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKusm_numeric_policy: policy_idpolicy_idvarchar(30)30
No
scaleint4
Yes
rounding_modeint4
Yes
negative_symbolvarchar(4)4
Yes
display_leading_zerostinyint1
Yes
typeint4
No
min_scaleint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKusm_numeric_policy: policy_idXPKusm_numeric_policypolicy_id
Yes
Permissions
TypeActionOwning Principal
GrantDeleteusmgroup
GrantInsertusmgroup
GrantReferencesusmgroup
GrantSelectusmgroup
GrantUpdateusmgroup
SQL Script
CREATE TABLE [dbo].[usm_numeric_policy]
(
[policy_id] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[scale] [int] NULL,
[rounding_mode] [int] NULL,
[negative_symbol] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[display_leading_zeros] [tinyint] NULL,
[type] [int] NOT NULL,
[min_scale] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_numeric_policy] ADD CONSTRAINT [XPKusm_numeric_policy] PRIMARY KEY CLUSTERED ([policy_id]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[usm_numeric_policy] TO [usmgroup]
GRANT SELECT ON  [dbo].[usm_numeric_policy] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_numeric_policy] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_numeric_policy] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_numeric_policy] TO [usmgroup]
GO
Uses