Application.SchemaName Property
Gets or sets the database schema for all application database objects.
Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Declaration
Public Property SchemaName As String
public string SchemaName { get; set; }
public:
property String^ SchemaName {
String^ get ();
void set (String^ value);
}
/** @property */
public String get_SchemaName ()
/** @property */
public void set_SchemaName (String value)
public function get SchemaName () : String
public function set SchemaName (value : String)
Property Value
A String, between 1 and 128 characters in length, containing the name of the database schema for application objects.
Remarks
Updated text:5 December 2005
You use this property along with the DatabaseName property to specify the database and schema for application objects.
Specify this property only if you are creating a new application. Existing applications already have a schema, and the schema name cannot be changed after creating the application. If you attempt to change a schema name, NMO throws an exception.
If you use the Application(Instance,String) constructor, the default schema is dbo. If you use the default constructor, you must set this property.
Example
The following example shows how to set the name of the application database and the schema for application objects:
myApplication.DatabaseName = "MyInstMyApp";
myApplication.SchemaName = "MyAppSchema";
myApplication.DatabaseName = "MyInstMyApp"
myApplication.SchemaName = "MyAppSchema"
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
See Also
Reference
Application Class
Application Members
Microsoft.SqlServer.Management.Nmo Namespace
Application.DatabaseName Property