TaxonomyTerms
List all terms of the taxonomies.
Table Specific Information
SELECT
The cmdlet uses the WordPress API to process some of the filters. The cmdlet processes other filters client-side within the cmdlet. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data. Note: Taxonomy is required to fetch TaxonomyTerms. Use the slug values from the taxonomies view to retrieve the taxonomy column value.
For example, the following queries are processed server side.
SELECT * FROM TaxonomyTerms WHERE Taxonomy = 'books';
SELECT * from WordPress.taxonomyterms WHERE taxonomy in ('post_tag','Category');
Columns
| Name | Type | Description |
| id | Integer | The id of the term in the taxonomy. |
| Count | Integer | Count of it's presence. |
| Link | String | Labels for the taxonomy for various contexts. |
| Name | String | The title for the taxonomy term. |
| Slug | String | An alphanumeric identifier for the taxonomy term. |
| Taxonomy | String | Taxonomy in which this term is present |
| Parent | Integer | The id of the parent taxonomy |
| Description | String | A description of the taxonomy term. |