CREATE TABLE [dbo].[db_Star]
(
[dbrep_IID] [int] NOT NULL,
[dbrep_isFlat] [tinyint] NULL,
[dbrep_isAggregated] [tinyint] NULL
) ON [PRIMARY]
GO
-- if delete a star schema - delete  info about tables & aggregations in star
CREATE TRIGGER del_db_Star ON db_Star FOR DELETE AS BEGIN DELETE FROM db_StarTable FROM deleted where db_StarTable.dbrep_StarIID = deleted.dbrep_IID DELETE FROM db_GatorStar FROM deleted where db_GatorStar.dbrep_StarIID = deleted.dbrep_IID END
GO
ALTER TABLE [dbo].[db_Star] ADD CONSTRAINT [PK__db_Star__658381CA] PRIMARY KEY CLUSTERED ([dbrep_IID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[db_Star] TO [InfoPumpAdmin]
GRANT INSERT ON  [dbo].[db_Star] TO [InfoPumpAdmin]
GRANT DELETE ON  [dbo].[db_Star] TO [InfoPumpAdmin]
GRANT UPDATE ON  [dbo].[db_Star] TO [InfoPumpAdmin]
GRANT SELECT ON  [dbo].[db_Star] TO [InfoPumpUsers]
GRANT INSERT ON  [dbo].[db_Star] TO [InfoPumpUsers]
GRANT DELETE ON  [dbo].[db_Star] TO [InfoPumpUsers]
GRANT UPDATE ON  [dbo].[db_Star] TO [InfoPumpUsers]
GO