Tables [dbo].[ReportGroupMap]
Properties
PropertyValue
Row Count (~)28
Created3:36:01 PM Tuesday, November 18, 2014
Last Modified3:36:01 PM Tuesday, November 18, 2014
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_ReportGroupMap: ReportGroupMapIDReportGroupMapIDint4
No
1 - 1
Foreign Keys FK_ReportGroupMap_Reports: [dbo].[Reports].ReportFIDIndexes IX_ReportGroupMap_ReportFID: ReportFIDReportFIDint4
No
Foreign Keys FK_ReportGroupMap_ReportGroup: [dbo].[ReportGroup].ReportGroupFIDReportGroupFIDint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_ReportGroupMap: ReportGroupMapIDPK_ReportGroupMapReportGroupMapID
Yes
IX_ReportGroupMap_ReportFIDReportFID
Yes
Foreign Keys Foreign Keys
NameColumns
FK_ReportGroupMap_ReportsReportFID->[dbo].[Reports].[Prikey]
FK_ReportGroupMap_ReportGroupReportGroupFID->[dbo].[ReportGroup].[ReportGroupID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[ReportGroupMap]
(
[ReportGroupMapID] [int] NOT NULL IDENTITY(1, 1),
[ReportFID] [int] NOT NULL,
[ReportGroupFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ReportGroupMap] ADD CONSTRAINT [PK_ReportGroupMap] PRIMARY KEY CLUSTERED  ([ReportGroupMapID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ReportGroupMap] ADD CONSTRAINT [IX_ReportGroupMap_ReportFID] UNIQUE NONCLUSTERED  ([ReportFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ReportGroupMap] ADD CONSTRAINT [FK_ReportGroupMap_Reports] FOREIGN KEY ([ReportFID]) REFERENCES [dbo].[Reports] ([Prikey])
GO
ALTER TABLE [dbo].[ReportGroupMap] ADD CONSTRAINT [FK_ReportGroupMap_ReportGroup] FOREIGN KEY ([ReportGroupFID]) REFERENCES [dbo].[ReportGroup] ([ReportGroupID])
GO
GRANT SELECT ON  [dbo].[ReportGroupMap] TO [MssExec]
GRANT INSERT ON  [dbo].[ReportGroupMap] TO [MssExec]
GRANT DELETE ON  [dbo].[ReportGroupMap] TO [MssExec]
GRANT UPDATE ON  [dbo].[ReportGroupMap] TO [MssExec]
GO
Uses