Tables [dbo].[e2e_wrm_countersource]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:13 AM Wednesday, March 07, 2007
Last Modified11:09:37 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
sourceidint4
No
localeidint4
No
((1033))
Indexes xak1e2e_wrm_countersource: sourcenamesourcenamechar(254)254
No
Indexes xie1e2e_wrm_countersource: hostnamehostnamechar(64)64
No
srctimezonefloat8
No
((0))
Indexes Indexes
NameColumnsUnique
xak1e2e_wrm_countersourcesourcename
Yes
xie1e2e_wrm_countersourcehostname
Permissions
TypeActionOwning Principal
GrantDeleteapmadmin
GrantInsertapmadmin
GrantSelectapmadmin
GrantUpdateapmadmin
SQL Script
CREATE TABLE [dbo].[e2e_wrm_countersource]
(
[sourceid] [int] NOT NULL,
[localeid] [int] NOT NULL CONSTRAINT [DF__e2e_wrm_c__local__2DBCB4E6] DEFAULT ((1033)),
[sourcename] [char] (254) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[hostname] [char] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[srctimezone] [float] NOT NULL CONSTRAINT [DF__e2e_wrm_c__srcti__2EB0D91F] DEFAULT ((0))
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xie1e2e_wrm_countersource] ON [dbo].[e2e_wrm_countersource] ([hostname]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [xak1e2e_wrm_countersource] ON [dbo].[e2e_wrm_countersource] ([sourcename]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[e2e_wrm_countersource] TO [apmadmin]
GRANT INSERT ON  [dbo].[e2e_wrm_countersource] TO [apmadmin]
GRANT DELETE ON  [dbo].[e2e_wrm_countersource] TO [apmadmin]
GRANT UPDATE ON  [dbo].[e2e_wrm_countersource] TO [apmadmin]
GO
Uses
Used By