# 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](https://docs.hivesql.io/technical-informations/operations/txcomments)) |
| `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'
```