CREATE TABLE [dbo].[iam_object]
(
[object_guid] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[object_name] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[location_name] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[object_class] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[object_link] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[product_instance_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_user] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[iam_object] ADD CONSTRAINT [XPKiam_object] PRIMARY KEY CLUSTERED ([object_guid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [xiu1iam_object] ON [dbo].[iam_object] ([location_name], [object_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2iam_object] ON [dbo].[iam_object] ([object_class]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif5iam_object] ON [dbo].[iam_object] ([object_link]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif4iam_object] ON [dbo].[iam_object] ([object_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1iam_object] ON [dbo].[iam_object] ([product_instance_name]) ON [PRIMARY]
GO