CREATE TABLE [dbo].[StoredQueries]
(
[queryID] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[queryName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[groupBy] [int] NULL,
[xsl] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[StoredQueries] ADD CONSTRAINT [pk_storedqueries] PRIMARY KEY CLUSTERED ([queryID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[StoredQueries] ADD CONSTRAINT [fk_storedqueries_div] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO
[dbo].[StoredQueries]
![Foreign Keys fk_storedqueries_div: [dbo].[Divisions].divisionID](../../Images/fk.gif)
