Tables [dbo].[zusp_lrel_0_0]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count99
Created4:41:29 PM Wednesday, March 24, 2010
Last Modified4:41:29 PM Wednesday, March 24, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key PK__zusp_lrel_0_0__48933A82: ididint4
No
Indexes zusp_lrel_0_0_X0: session_log\crsession_logint4
Yes
Indexes zusp_lrel_0_0_X1: crIndexes zusp_lrel_0_0_X0: session_log\crcrnvarchar(100)200
Yes
last_mod_dtint4
Yes
last_mod_bybinary(16)16
Yes
Indexes zusp_lrel_0_0_X2: tenanttenantbinary(16)16
Yes
Indexes Indexes
NameColumnsUnique
Primary Key PK__zusp_lrel_0_0__48933A82: idPK__zusp_lrel_0_0__48933A82id
Yes
zusp_lrel_0_0_X0session_log, cr
Yes
zusp_lrel_0_0_X1cr
zusp_lrel_0_0_X2tenant
Permissions
TypeActionOwning Principal
GrantDeletepublic
GrantInsertpublic
GrantSelectpublic
GrantUpdatepublic
SQL Script
CREATE TABLE [dbo].[zusp_lrel_0_0]
(
[id] [int] NOT NULL,
[session_log] [int] NULL,
[cr] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL,
[tenant] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[zusp_lrel_0_0] ADD CONSTRAINT [PK__zusp_lrel_0_0__48933A82] PRIMARY KEY NONCLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [zusp_lrel_0_0_X1] ON [dbo].[zusp_lrel_0_0] ([cr]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [zusp_lrel_0_0_X0] ON [dbo].[zusp_lrel_0_0] ([session_log], [cr]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [zusp_lrel_0_0_X2] ON [dbo].[zusp_lrel_0_0] ([tenant]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[zusp_lrel_0_0] TO [public]
GRANT INSERT ON  [dbo].[zusp_lrel_0_0] TO [public]
GRANT DELETE ON  [dbo].[zusp_lrel_0_0] TO [public]
GRANT UPDATE ON  [dbo].[zusp_lrel_0_0] TO [public]
GO
Uses