CREATE TABLE [dbo].[DDTable]
(
[DDTableId] [dbo].[IDENTIFIER_TYPE] NOT NULL,
[RequestId] [dbo].[IDENTIFIER_TYPE] NULL,
[ExecutionId] [dbo].[IDENTIFIER_TYPE] NULL,
[DDUserId] [dbo].[IDENTIFIER_TYPE] NOT NULL,
[DDProviderId] [dbo].[IDENTIFIER_TYPE] NOT NULL,
[DDDatabaseName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DDTableName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DDTableNote] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DDTableCreateTime] [dbo].[DATETIME_TYPE] NOT NULL
) ON [PRIMARY]
GO
-- add it triggers for deleting FKey Refs
CREATE TRIGGER dbdel_DDTable ON DDTable FOR DELETE AS BEGIN DELETE FROM DDColumn FROM deleted WHERE DDColumn.DDTableId = deleted.DDTableId END
GO
ALTER TABLE [dbo].[DDTable] ADD CONSTRAINT [pk_DDTable] PRIMARY KEY CLUSTERED ([DDTableId]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[DDTable] TO [InfoPumpAdmin]
GRANT INSERT ON  [dbo].[DDTable] TO [InfoPumpAdmin]
GRANT DELETE ON  [dbo].[DDTable] TO [InfoPumpAdmin]
GRANT UPDATE ON  [dbo].[DDTable] TO [InfoPumpAdmin]
GRANT SELECT ON  [dbo].[DDTable] TO [InfoPumpUsers]
GRANT DELETE ON  [dbo].[DDTable] TO [InfoPumpUsers]
GRANT SELECT ON  [dbo].[DDTable] TO [public]
GO