[dbo].[FunctionArgs]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	35
Created	12:44:46 PM Thursday, October 04, 2007
Last Modified	12:44:46 PM Thursday, October 04, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)	Identity
$Cluster Primary Key PK__FunctionArgs__27C3E46E: functionID\arg_name$	functionID	int	4
$Cluster Primary Key PK__FunctionArgs__27C3E46E: functionID\arg_name$	arg_name	nvarchar(75)	150
	description	nvarchar(255)	510
	index_value	int	4	1 - 1

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

$Cluster Primary Key PK__FunctionArgs__27C3E46E: functionID\arg_name$

functionID

int

$Cluster Primary Key PK__FunctionArgs__27C3E46E: functionID\arg_name$

arg_name

nvarchar(75)

150

description

nvarchar(255)

510

index_value

int

1 - 1

	Name	Columns	Unique
$Cluster Primary Key PK__FunctionArgs__27C3E46E: functionID\arg_name$	PK__FunctionArgs__27C3E46E	functionID, arg_name

Name

Columns

Unique

$Cluster Primary Key PK__FunctionArgs__27C3E46E: functionID\arg_name$

PK__FunctionArgs__27C3E46E

functionID, arg_name

Name	Columns
FK__FunctionA__funct__28B808A7	functionID->[dbo].[LibFunctions].[functionID]

Name

Columns

FK__FunctionA__funct__28B808A7

functionID->[dbo].[LibFunctions].[functionID]

SQL Script

CREATE TABLE [dbo].[FunctionArgs]
(
[functionID] [int] NOT NULL,
[arg_name] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[index_value] [int] NOT NULL IDENTITY(1, 1)
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FunctionArgs] ADD CONSTRAINT [PK__FunctionArgs__27C3E46E] PRIMARY KEY CLUSTERED ([functionID], [arg_name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FunctionArgs] ADD CONSTRAINT [FK__FunctionA__funct__28B808A7] FOREIGN KEY ([functionID]) REFERENCES [dbo].[LibFunctions] ([functionID])
GO