Tables [dbo].[ud_orgdef_list]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created12:31:22 PM Sunday, December 05, 2010
Last Modified12:31:22 PM Sunday, December 05, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
olorgnamenvarchar(50)100
No
Indexes ud_orgdef_list_ak1: oluserlistoluserlistnvarchar(255)510
No
(' ')
olnotenvarchar(127)254
No
(' ')
Indexes ud_orgdef_list_ak2: oldivoldivnvarchar(127)254
No
(' ')
Indexes Indexes
NameColumns
ud_orgdef_list_ak1oluserlist
ud_orgdef_list_ak2oldiv
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
SQL Script
CREATE TABLE [dbo].[ud_orgdef_list]
(
[olorgname] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[oluserlist] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ud_orgdef__oluse__3A792834] DEFAULT (' '),
[olnote] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ud_orgdef__olnot__3B6D4C6D] DEFAULT (' '),
[oldiv] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ud_orgdef__oldiv__3C6170A6] DEFAULT (' ')
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [ud_orgdef_list_ak2] ON [dbo].[ud_orgdef_list] ([oldiv]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ud_orgdef_list_ak1] ON [dbo].[ud_orgdef_list] ([oluserlist]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ud_orgdef_list] TO [aiadmin]
GRANT INSERT ON  [dbo].[ud_orgdef_list] TO [aiadmin]
GRANT DELETE ON  [dbo].[ud_orgdef_list] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ud_orgdef_list] TO [aiadmin]
GRANT SELECT ON  [dbo].[ud_orgdef_list] TO [aipublic]
GO
Uses
Used By