> For the complete documentation index, see [llms.txt](https://docs.hivesql.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.hivesql.io/technical-informations/state-tables/tags.md).

# Tags

This table stores all the tags of all the posts published.

#### Columns

| Name         | Description                                                                                                                             |
| ------------ | --------------------------------------------------------------------------------------------------------------------------------------- |
| `comment_id` | a foreign key containing the ID of the post in the Comments table. (see [TxComments](/technical-informations/operations/txcomments.md)) |
| `tag`        | one of the tags used to publish the post                                                                                                |

#### Query example

To retrieve all posts related to a specific tag, for example *cats*, you can issue the following SQL query:

```
SELECT
    Comments.author, 
    Comments.permlink
FROM
    Tags
    INNER JOIN Comments ON Tags.comment_id = Comments.ID
WHERE
    Tags.tag = 'cats'
```