Instance.SchemaName Property

아티클
12/15/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 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

Instance Class
Instance Members
Microsoft.SqlServer.Management.Nmo Namespace

다음을 통해 공유