Open topic with navigation

SQLFUNCTIONCATALOG (4.0SP11)

The SQLFUNCTIONCATALOG table contains meta data about application related stored functions added to the system.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT
Fields
Field Field Type Null Notes Description

FUNCTIONNAME

nvarchar(128)

false

''

Name of the function

DESCRIPTION

nvarchar(max)

false

''

A description of the functionality of the function.

SQLFUNCTIONSPECXML

xml

false

Contains the xml definition from which the function Was built.

DATEADDED

datetime

false

getdate()

Indicates the date this record was added

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed

TS

timestamp

false

Timestamp

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp

MARTKEY

nvarchar(255)

true

Indexes
Index Name Field(s) Unique Primary Clustered

IX_SQLFUNCTIONCATALOG_DATEADDED

DATEADDED

False

False

True

PK_SQLFUNCTIONCATALOG

ID

True

True

False

UC_SQLFUNCTIONCATALOG_FUNCTIONNAME

FUNCTIONNAME

True

False

False
Triggers
Trigger Name Description

TR_SQLFUNCTIONCATALOG_AUDIT_UPDATE

TR_SQLFUNCTIONCATALOG_AUDIT_DELETE

Referenced by
Referenced by Field

SPONSORSHIPPROGRAM

MATCHFUNCTIONID