다음을 통해 공유


SchemaName Element (ICF)

Specifies the database schema for all instance database objects.

구문

<Database>
    <DatabaseName>

Element Characteristics

Characteristic Description

Data type

string, between 1 and 128 characters in length.

Default value

dbo.

Occurrence

Optional once per Database element. Required if using the DatabaseName element.

Updates

Cannot be added, deleted, or modified when updating the application.

Element Relationships

Relationship Elements

Parent element

Database Element (ICF)

Child elements

None.

주의

In SQL Server 2005 Notification Services, you can specify the name of the instance database. This database can be a new or existing database. Because the instance database objects should be isolated from other instance or application database objects, you should specify a unique schema name if you specify a database name.

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, where instanceName is the value of the InstanceName element, and creates all instance objects in the dbo schema.

For more information about database schemas, see 사용자와 스키마 분리.

The following example shows how define an NSInstance schema for all instance objects.

<SchemaName>NSInstance</SchemaName>

참고 항목

참조

Application Definition File Reference

개념

Instance Configuration File Reference

관련 자료

인스턴스 데이터베이스 정의
CREATE SCHEMA(Transact-SQL)
인스턴스 및 응용 프로그램 업데이트

도움말 및 정보

SQL Server 2005 지원 받기