SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Programming Reference
Database Engine Administration Programming
SQL-DMO
SQL-DMO Reference
Properties (SQL-DMO)
C (SQL-DMO Properties)
CaseSensitive Property
Catalog Property
Category Property
CentralizedConflicts Property
CharacterSet Property
Checked Property
CheckPermissions Property
Clustered Property
CmdExecSuccessCode Property
CodePage Property
Collation Property
CollationName Property
ColumnDelimiter Property
ColumnMaxLength Property
ColumnName Property
Columns Property
ColumnsNullByDefault Property
ColumnTracking Property
ColumnType Property
Command Property
CommandOptions Property
CommandTerminator Property
CompareNull Property
CompatibilityLevel Property (Database)
CompatibilityLevel Property (MergePublication2, TransPublication2)
ComputedText Property
ConflictPolicy Property
ConflictRetention Property
ConflictTable Property
ConnectionID Property
ConnectTimeout Property
ContactNull Property
CopyAllDefaults Property
CopyAllFunctions Property
CopyAllObjects Property
CopyAllRules Property
CopyAllStoredProcedures Property
CopyAllTables Property
CopyAllTriggers Property
CopyAllUserDefinedDatatypes Property
CopyAllViews Property
CopyData Property
CopySchema Property
CountResetDate Property
CreateDate Property
CreateForAttach Property
CreationScriptOptions Property
CreationScriptPath Property
CurrentCompatibility Property
CurrentExecutionStatus Property
CurrentResultSet Property
CurrentRunRetryAttempt Property
CurrentRunStatus Property
CurrentRunStep Property
CurrentValue Property
CursorCloseOnCommit Property
Count Property
CountResetTime Property
Expand Minimize
This topic has not yet been rated - Rate this topic

CopyAllViews Property

SQL Server 2005

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The CopyAllViews property controls the transfer of Microsoft SQL Server views from the source to the target database.

Copy 

object
.CopyAllViews [=value]
object

An expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Boolean

Read/write

Copy 
HRESULT GetCopyAllViews(LPBOOL pRetVal);
HRESULT SetCopyAllViews(BOOL NewValue);

If TRUE, all SQL Server views in the source database are copied to the target.

If FALSE, only views indicated by the AddObject and AddObjectByName methods are copied.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.