# Categories: Discourse Categories Get a list of categories The Categories endpoint returns a list of all the categories for your discourse site that you have access to. - Catalog: `Discourse` - Schema: `Categories` - Label: Categories This is a read-only table. The Discourse API may not support changing the data or the Invantive UniversalSQL driver for Discourse does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Discourse API. ## Table Columns The columns of the table `Categories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `background_url` | `varchar2` | Background URL | ☐ | | | `can_create_category` | `char` | Can Create Category | ☐ | | | `can_create_topic` | `char` | Can Create Topic | ☐ | | | `can_edit` | `char` | Can Edit | ☐ | | | `can_vote` | `char` | | ☐ | | | `color` | `varchar2` | Colour | ☐ | | | `default_list_filter` | `varchar2` | | ☐ | | | `default_top_period` | `varchar2` | | ☐ | | | `default_view` | `varchar2` | | ☐ | | | `description_excerpt` | `varchar2` | Description Excerpt | ☐ | | | `description_text` | `varchar2` | Description Text | ☐ | | | `description` | `varchar2` | Description | ☐ | | | `draft_key` | `varchar2` | Draft Key | ☐ | | | `draft_sequence` | `int64` | Draft Sequence | ☐ | | | `draft` | `char` | Draft | ☐ | | | `has_children` | `char` | Has Children | ☐ | | | `id` | `int64` | ID | ☐ | | | `is_uncategorized` | `char` | | ☐ | | | `logo_url` | `varchar2` | Logo URL | ☐ | | | `minimum_required_tags` | `int32` | | ☐ | | | `name` | `varchar2` | Name | ☐ | | | `navigate_to_first_post_after_read` | `char` | | ☐ | | | `notification_level` | `varchar2` | Notification Level | ☐ | | | `num_featured_topics` | `int32` | | ☐ | | | `permission` | `int64` | Permission | ☐ | | | `position` | `int64` | Position | ☐ | | | `post_count` | `int64` | #Posts | ☐ | | | `read_restricted` | `char` | Read Restricted | ☐ | | | `show_subcategory_list` | `char` | | ☐ | | | `slug` | `varchar2` | Slug | ☐ | | | `sort_order` | `varchar2` | Sort Order | ☐ | | | `subcategory_list_style` | `varchar2` | | ☐ | | | `text_color` | `varchar2` | Text Colour | ☐ | | | `topic_count` | `int64` | #Topics | ☐ | | | `topic_template` | `varchar2` | Topic Template | ☐ | | | `topic_url` | `varchar2` | Topic URL | ☐ | | | `topics_all_time` | `int64` | Topics All Time | ☐ | | | `topics_day` | `int64` | Topics Day | ☐ | | | `topics_month` | `int64` | Topics Month | ☐ | | | `topics_week` | `int64` | Topics Week | ☐ | | | `topics_year` | `int64` | Topics Year | ☐ | | | `uploaded_logo_height` | `int32` | | ☐ | | | `uploaded_logo_id` | `int32` | | ☐ | | | `uploaded_logo_url` | `varchar2` | | ☐ | | | `uploaded_logo_width` | `int32` | | ☐ | |