AddStandardPatterns Procedure (Repository.Item 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.]
Adds standard Modeling Services design patterns to a target view and underlying table. This procedure combines calls to several stored procedures related to Modeling Services patterns. These procedures include [Repository].[CreateIdSequence], [Repository.Item].[AddFolderForeignKey], and [Repository.Item].[AddViewsInsteadOfTriggers]. Depending on the installed settings, it also calls the procedures [Repository.Item].[AddAuditing] and [Repository.Item].[AddChangeTracking].
[Repository.Item].[AddStandardPatterns] ( @schema, @baseName, @sequenceSchema, @sequence )
Arguments
@schema
Type: sysname. The schema of the target view.
@baseName
Type: nvarchar(99). The name of the target view.
@sequenceSchema
Type: sysname. An optional schema for the sequence object. If this value is not provided, the sequence object uses the schema name of the target view.
@sequence
Type: sysname. An optional sequence object name. If this value is not provided, the sequence object uses the name of the target view.