AddStandardPatterns Procedure (Repository.Item Schema) Home
AddStandardPatterns Procedure (Repository.Item Schema)

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.
Remarks
See Also

Reference

Repository.Item Procedures
Repository.Item Schema

Send comments about this topic to Microsoft.

© 2009 Microsoft Corporation. All rights reserved.   Terms of Use | Trademarks | Privacy Statement
Page view tracker
Rate the Lightweight library
x
Lightweight builds on ScriptFree (loband) by adding features you've requested: a SearchBox and default code language selection.
Do you like the SearchBox?
Do you like the tabbed code blocks?
How useful is this topic?
Tell us more.
Thanks
x
You're helping to improve MSDN Online.
Feedback
Switch View
x
Classic
Lightweight Beta
ScriptFree
Switch View