table-element-for-schema-dta.md

title	Table Element for Schema (DTA)
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	tools-other
ms.topic	conceptual
dev_langs	XML
helpviewer_keywords	Table element [DTA]
ms.assetid	a59e8319-05d1-47f3-af39-7d970ab8e7dc
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer
ms.custom	seo-lt-2019
ms.date	03/01/2017

Table Element for Schema (DTA)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

Specifies the table for tuning.

Syntax

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

Element Attributes

Attribute	Description
NumberOfRows	Optional. Integer that allows you to simulate tables of different sizes.

Element Characteristics

Characteristic	Description
Data type and length	string, between 1 and 255 characters.
Default value	None.
Occurrence	Optional. List as many tables as appropriate for your workload.

Element Relationships

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

Remarks

If you do not specify a Table element, Database Engine Tuning Advisor will assume all tables on the specified database can be tuned.

Example

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

See Also

XML Input File Reference (Database Engine Tuning Advisor)