SQL-Unit  1.6
Typedefs
Types.ssunit.sql File Reference

The public user defined types. More...

Typedefs

typedef varchar[128] SchemaName
 The name of an object's schema.
typedef varchar[257] ProcedureName
 The fully qualified name of a stored procedure.
typedef varchar[257] TableName
 The fully qualified name of a table.
typedef varchar[max] TextMessage
 A text message, such as the reason for a test failure.
typedef int Version
 The version number as a single integer.

Detailed Description

The public user defined types.

Author:
Chris Oldwood

Typedef Documentation

typedef varchar [257] ProcedureName

The fully qualified name of a stored procedure.

The type includes space for the schema name, separator and procedure name (128 + 1 + 128).

typedef varchar [128] SchemaName

The name of an object's schema.

typedef varchar [257] TableName

The fully qualified name of a table.

The type includes space for the schema name, separator and table name (128 + 1 + 128).

typedef varchar [max] TextMessage

A text message, such as the reason for a test failure.

typedef int Version

The version number as a single integer.

For example v1.5.0 is represented as the integer 150. This allows for the standard arithmetic operators to be used for comparison.