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.
Data Types (UDTs)
| Type | Description |
|---|---|
A Uniform Modeling Services Identifier data type that resolves to a unicode string that has a maximum of 4166 characters. |
Procedures
| Procedure | Description |
|---|---|
Creates a Modeling Services database login and user, assigning the new user to the specified Modeling Services role. |
|
Creates a named sequence object that obtains one or more valid identifiers for newly inserted rows. |
|
Creates an alias for a sequence object that can be used to provide unique identifiers across multiple views or tables. |
|
Raises a SQL Server error message. This procedure is called by other Modeling Services functions and procedures. |
|
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. |
|
An infrastructure routine that formats an error string with the provided values and then raises a SQL Server error with the formatted message. |
|
Returns one or more unique identifiers for the given sequence object or sequence alias. |
|
Raises a SQL Server error message for a Modeling Services error event. |
|
Raises an error when a Modeling Services constraint is violated. |
|
Raises an error when a Modeling Services procedure is called with an incorrect parameter value. |
|
Raises an error when there is an attempt to change a read-only column in a Modeling Services table. |
|
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. |
|
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. |
|
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. |
|
Raises a SQL Server warning message for a Modeling Services warning. |
|
Removes a Windows principal from accessing the Modeling Services database. |
Functions
| Function | Description |
|---|---|
Returns the number of characters in a target unicode string. |
|
Returns the number of characters in a target ASCII string. |
|
Returns a string that lists the columns and their types for a SQL Server object. This is an internal procedure used by Modeling Services. |
|
Returns the value of the associated Modeling Services setting. |
Tables
| Table | Description |
|---|---|
Stores sequence object aliases. Do not access this table directly. Instead use the [Repository].[CreateIdSequenceAlias] and [Repository].[NewIdInterval] stored procedures. |
|
Stores sequence objects. Do not access this table directly. Instead use the [Repository].[CreateIdSequence] and [Repository].[NewIdInterval] stored procedures. |