text: ﻿CREATE TABLE [dbo].[WorkgroupsXOrganizations] (
      [WorkgroupId]    INT          NOT NULL,
      [OrganizationId] VARCHAR (10) NOT NULL,
      PRIMARY KEY CLUSTERED ([WorkgroupId] ASC, [OrganizationId] ASC) WITH (STATISTICS_NORECOMPUTE = ON),
      CONSTRAINT [FK_WorkgroupsXOrganizations_Workgroups] FOREIGN KEY ([WorkgroupId]) REFERENCES [dbo].[Workgroups] ([Id])
  );
  
  
  
  
  
  GO
  CREATE NONCLUSTERED INDEX [WorkgroupsXOrganizations_WorkgroupId_IDX]
      ON [dbo].[WorkgroupsXOrganizations]([WorkgroupId] ASC) WITH (STATISTICS_NORECOMPUTE = ON);
  
  
  
  
  GO
  CREATE NONCLUSTERED INDEX [WorkgroupsXOrgainzations_OrganizationId_IDX]
      ON [dbo].[WorkgroupsXOrganizations]([OrganizationId] ASC) WITH (STATISTICS_NORECOMPUTE = ON);
  
  
  
  