CREATE TABLE [dbo].[db_Table]
(
[dbrep_IID] [int] NOT NULL,
[dbrep_TableType] [smallint] NULL,
[dbrep_starRole] [int] NULL
) ON [PRIMARY]
GO
-- if you delete a table - delete the info in the star schema & flat file info
CREATE TRIGGER del_db_Table ON db_Table FOR DELETE AS BEGIN DELETE FROM db_SeqTable FROM deleted where db_SeqTable.dbrep_IID = deleted.dbrep_IID DELETE FROM db_StarTable FROM deleted where db_StarTable.dbrep_TableIID = deleted.dbrep_IID END
GO
ALTER TABLE [dbo].[db_Table] ADD CONSTRAINT [PK__db_Table__57356273] PRIMARY KEY CLUSTERED ([dbrep_IID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[db_Table] TO [InfoPumpAdmin]
GRANT INSERT ON  [dbo].[db_Table] TO [InfoPumpAdmin]
GRANT DELETE ON  [dbo].[db_Table] TO [InfoPumpAdmin]
GRANT UPDATE ON  [dbo].[db_Table] TO [InfoPumpAdmin]
GRANT SELECT ON  [dbo].[db_Table] TO [InfoPumpUsers]
GRANT INSERT ON  [dbo].[db_Table] TO [InfoPumpUsers]
GRANT DELETE ON  [dbo].[db_Table] TO [InfoPumpUsers]
GRANT UPDATE ON  [dbo].[db_Table] TO [InfoPumpUsers]
GO