Export (0) Print
Expand All

Repository Schema

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

Provides support for core services in the Modeling Services. These services include error handling and support for sequence objects.

Type Description

Uri

A Uniform Modeling Services Identifier data type that resolves to a unicode string that has a maximum of 4166 characters.

Procedure Description

AddPrincipal

Creates a Modeling Services database login and user, assigning the new user to the specified Modeling Services role.

CreateIdSequence

Creates a named sequence object that obtains one or more valid identifiers for newly inserted rows.

CreateIdSequenceAlias

Creates an alias for a sequence object that can be used to provide unique identifiers across multiple views or tables.

HandleModuleFailure

Raises a SQL Server error message. This procedure is called by other Modeling Services functions and procedures.

InitializeServer

Initializes a SQL Server instance to support the Modeling Services database. This must be called once for Modeling Services databases that are moved to new SQL Server instances.

InternalRaiseError

An infrastructure routine that formats an error string with the provided values and then raises a SQL Server error with the formatted message.

NewIdInterval

Returns one or more unique identifiers for the given sequence object or sequence alias.

RaiseError

Raises a SQL Server error message for a Modeling Services error event.

RaiseErrorConstraintViolated

Raises an error when a Modeling Services constraint is violated.

RaiseErrorParameter

Raises an error when a Modeling Services procedure is called with an incorrect parameter value.

RaiseErrorReadOnlyColumn

Raises an error when there is an attempt to change a read-only column in a Modeling Services table.

RaiseErrorSubsetConstraintViolated

Raises an error when a subset constraint is violated. A subset constraint specifies that the values in one column must be a subset of those in another column.

RaiseErrorSubsetConstraintViolated2

Raises an error when a subset constraint is violated. A subset constraint specifies that the values in one column must be a subset of those in another column. Unlike the [Repository].[RaiseErrorSubsetConstraintViolated] procedure, this procedure is used for subset constraints that involve multiple columns.

RaiseErrorUniqueConstraintViolated

Raises an error when a unique constraint is violated on a column. The unique constraint specifies that all values for a given column must be unique.

RaiseWarning

Raises a SQL Server warning message for a Modeling Services warning.

RemovePrincipal

Removes a Windows principal from accessing the Modeling Services database.

Function Description

LengthNVarChar

Returns the number of characters in a target unicode string.

LengthVarChar

Returns the number of characters in a target ASCII string.

RelationsSignature

Returns a string that lists the columns and their types for a SQL Server object. This is an internal procedure used by Modeling Services.

Setting

Returns the value of the associated Modeling Services setting.

Table Description

IdSequenceAliasesTable

Stores sequence object aliases. Do not access this table directly. Instead use the [Repository].[CreateIdSequenceAlias] and [Repository].[NewIdInterval] stored procedures.

IdSequencesTable

Stores sequence objects. Do not access this table directly. Instead use the [Repository].[CreateIdSequence] and [Repository].[NewIdInterval] stored procedures.

Send comments about this topic to Microsoft.

Show:
© 2014 Microsoft