Application.SchemaName Property

Artículo
12/15/2008

Gets or sets the database schema for all application database objects.

Espacio de nombres: Microsoft.SqlServer.Management.Nmo
Ensamblado: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Sintaxis

'Declaración
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)

Valor de propiedad

A String, between 1 and 128 characters in length, containing the name of the database schema for application objects.

Notas

Texto actualizado:5 de diciembre de 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.

Ejemplo

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"

Seguridad para subprocesos

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.