Instance.SchemaName Property

發行項
12/16/2008

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

命名空間: Microsoft.SqlServer.Management.Nmo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

語法

'宣告
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)

屬性值

A String, between 1 and 128 characters in length, that specifies the schema name.

備註

In Microsoft SQL Server 2005 Notification Services, you can specify the DatabaseName. Because you can deploy multiple instances and applications to the same database, you must specify a different schema name for each instance and application. This allows database objects of multiple instances and applications to be isolated and prevents collisions across instances and applications.

All instance database objects are created in the specified schema.

If you do not specify the database name and schema name, Notification Services creates a new database with the name instanceNameNSMain, and creates all instance objects in the dbo schema.

For more information about database schemas, see 使用者結構描述分隔.

範例

The following examples show how to specify a name for the instance database and a schema for instance objects:

myInstance.DatabaseName = "MyInstNSMain";
myInstance.SchemaName = "MyInstSchema";

myInstance.DatabaseName = "MyInstNSMain"
myInstance.SchemaName = "MyInstSchema"

執行緒安全性

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.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台