For a list of all members of this type, see MakeQueryTable members.
Public Properties
| | Name | Description |
|---|
 | Alias | The alias for this tool's toolbox. |
| in_field | The fields to include in the layer or table view. If an alias is set for a field, this is the name that appears. If no fields are specified, all fields from all tables are included. (In, Optional) |
| in_key_field | Specifies a field or combination of fields that can be used to uniquely identify a row in the query. This parameter is used only when the USE_KEY_FIELDS option is set. (In, Optional) |
| in_key_field_option | Indicates how an ObjectID field will be generated, if at all, for the query. The default is USE_KEY_FIELDS. (In, Required) |
| in_table | The name of the table or tables to be used in the query. If several tables are listed, the Expression parameter can be used to define how they are to be joined. (In, Required) |
| out_table | The name of the layer or table view that will be created by the tool. (Out, Required) |
| ParameterInfo | The parameters used by this tool. For internal use only. |
| ToolboxDirectory | The directory of this tool's toolbox. |
| ToolboxName | The name of this tool's toolbox. |
| ToolName | The name of this tool. |
| where_clause | An SQL expression used to select a subset of records. The syntax for the expression differs slightly depending on the data source. For example, if you're querying file or ArcSDE geodatabases, shapefiles, coverages, dBase, or INFO tables, enclose field names in double quotes: (In, Optional) |
TopSee Also
