Adds standard “Oslo” repository design patterns to a target view and underlying table. This procedure combines calls to several stored procedures related to “Oslo” repository 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 )
@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.