[dbo].[Expressions]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	0
Created	12:44:45 PM Thursday, October 04, 2007
Last Modified	12:44:45 PM Thursday, October 04, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

Created

12:44:45 PM Thursday, October 04, 2007

Last Modified

12:44:45 PM Thursday, October 04, 2007

Name	Data Type	Max Length (Bytes)
queryID	int	4
exprOrder	int	4
combiner	nvarchar(5)	10
openBracketCount	int	4
closeBracketCount	int	4
fieldID	int	4
conditionID	int	4
exprDate	datetime	8
exprValue	nvarchar(500)	1000

Name

Data Type

Max Length (Bytes)

Allow Nulls

queryID

int

exprOrder

int

combiner

nvarchar(5)

openBracketCount

int

closeBracketCount

int

fieldID

int

conditionID

int

exprDate

datetime

exprValue

nvarchar(500)

1000

Name	Columns
fk_expressions_query	queryID->[dbo].[StoredQueries].[queryID]

Name

Columns

fk_expressions_query

queryID->[dbo].[StoredQueries].[queryID]

SQL Script

CREATE TABLE [dbo].[Expressions]
(
[queryID] [int] NOT NULL,
[exprOrder] [int] NOT NULL,
[combiner] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[openBracketCount] [int] NULL,
[closeBracketCount] [int] NULL,
[fieldID] [int] NULL,
[conditionID] [int] NULL,
[exprDate] [datetime] NULL,
[exprValue] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Expressions] ADD CONSTRAINT [fk_expressions_query] FOREIGN KEY ([queryID]) REFERENCES [dbo].[StoredQueries] ([queryID])
GO