CREATE TABLE [dbo].[StoredSQLQueries]
(
[queryID] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[queryName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[displayMethod] [int] NULL CONSTRAINT [DF__StoredSQL__displ__7FEAFD3E] DEFAULT ((0)),
[queryString] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[xslString] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[StoredSQLQueries] ADD CONSTRAINT [fk_storedsqlqueries_div] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO