Tables [dbo].[strlst]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:32 AM Wednesday, March 07, 2007
Last Modified11:09:45 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Indexes baseidx_strlst: _slid\slentry_slidsmallint2
Yes
Indexes baseidx_strlst: _slid\slentryslentrysmallint2
Yes
slvalue1varchar(60)60
Yes
slvalue2varchar(60)60
Yes
slchgrstvarchar(20)20
Yes
sldatestdatetime8
Yes
sltimestvarchar(6)6
Yes
sltmestpbinary(8)8
Yes
Indexes Indexes
NameColumnsUnique
baseidx_strlst_slid, slentry
Yes
Permissions
TypeActionOwning Principal
GrantDeleteca_itrm_group
GrantInsertca_itrm_group
GrantSelectca_itrm_group
GrantUpdateca_itrm_group
GrantSelectupmuser_group
GrantSelectca_itrm_group_ams
GrantSelectams_group
SQL Script
CREATE TABLE [dbo].[strlst]
(
[_slid] [smallint] NULL,
[slentry] [smallint] NULL,
[slvalue1] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[slvalue2] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[slchgrst] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sldatest] [datetime] NULL,
[sltimest] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sltmestp] [binary] (8) NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_strlst] ON [dbo].[strlst] ([_slid], [slentry]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[strlst] TO [ams_group]
GRANT SELECT ON  [dbo].[strlst] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[strlst] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[strlst] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[strlst] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[strlst] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[strlst] TO [upmuser_group]
GO
Uses