CREATE TABLE [dbo].[dbh_sql_tables_ora]
(
[sql_id] [decimal] (8, 0) NOT NULL,
[table_owner] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[table_name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[object_id] [decimal] (12, 0) NULL,
[object_type] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[dbh_sql_tables_ora] ADD CONSTRAINT [dbh_sql_tables_ora_pk] PRIMARY KEY CLUSTERED ([sql_id], [table_owner], [table_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [dbh_sql_tables_ora_table_idx] ON [dbo].[dbh_sql_tables_ora] ([table_owner], [table_name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[dbh_sql_tables_ora] ADD CONSTRAINT [dbh_sql_tables_ora_sql_fk] FOREIGN KEY ([sql_id]) REFERENCES [dbo].[dbh_sql_ora] ([sql_id]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[dbh_sql_tables_ora] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[dbh_sql_tables_ora] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[dbh_sql_tables_ora] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[dbh_sql_tables_ora] TO [udmadmin_group]
GO