schema-element-for-database-dta.md

title	Schema Element for Database (DTA)
description	In the dta utility, the Schema element for Database specifies the schema of the database that you want to tune.
author	rwestMSFT
ms.author	randolphwest
ms.date	03/01/2017
ms.service	sql
ms.subservice	tools-other
ms.topic	reference
ms.collection	data-tools
helpviewer_keywords	Schema element
dev_langs	XML

Schema Element for Database (DTA)

[!INCLUDE SQL Server]

Specifies the schema of the database that you want to tune.

Syntax

  
<Database>  
...code removed here...  
    <Schema>...</Schema>  

Element Characteristics

Characteristic	Description
Data type and length	None.
Default value	None.
Occurrence	Required once for the Database element that is specified under the Server element.

Element Relationships

Relationship	Elements
Parent element	Database Element for Server (DTA)
Child elements	Name Element for Schema (DTA) Table Element for Schema (DTA)

Example

For a usage example of this element, see Server Element (DTA).

See Also

XML Input File Reference (Database Engine Tuning Advisor)