Tables [dbo].[StoredSQLQueries]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created12:44:45 PM Thursday, October 04, 2007
Last Modified12:44:45 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
queryIDint4
No
1 - 1
Foreign Keys fk_storedsqlqueries_div: [dbo].[Divisions].divisionIDdivisionIDint4
No
queryNamenvarchar(50)100
Yes
displayMethodint4
Yes
((0))
queryStringntextmax
Yes
xslStringntextmax
Yes
Foreign Keys Foreign Keys
NameColumns
fk_storedsqlqueries_divdivisionID->[dbo].[Divisions].[divisionID]
SQL Script
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
Uses