SchemaName Element (ADF)
Specifies the database schema for all application 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 instance. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
주의
In SQL Server 2005 Notification Services, you can specify the name of the application database. This database can be a new or existing database. Because the application database objects must be isolated from other instance or application database objects, you should specify a unique schema name if you specify a database name. For more information about database schemas, see 사용자와 스키마 분리.
All application 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 instanceName + applicationName, and creates all application database objects in the dbo schema. The instance name and application name are specified in the instance configuration file (ICF).
For more information about database schemas, see 사용자와 스키마 분리.
예
The following example shows how define a Stock schema for all application database objects.
<SchemaName>Stock</SchemaName>
참고 항목
참조
Application Definition File Reference
개념
Instance Configuration File Reference
관련 자료
응용 프로그램 데이터베이스 정의
사용자와 스키마 분리
CREATE SCHEMA(Transact-SQL)
인스턴스 및 응용 프로그램 업데이트