> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_ft_default_stopword-table.md).

# Information Schema INNODB\_FT\_DEFAULT\_STOPWORD Table

The INNODB\_FT\_DEFAULT\_STOPWORD table lists the default stop words used by InnoDB FULLTEXT indexes when no custom stopword list is defined.

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `INNODB_FT_DEFAULT_STOPWORD` table contains a list of default [stopwords](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/full-text-indexes/full-text-index-stopwords.md) used when creating an InnoDB [fulltext index](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/full-text-indexes.md).

The [PROCESS](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#process) privilege is required to view the table.

It has the following column:

| Column | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| VALUE  | Default [stopword](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/full-text-indexes/full-text-index-stopwords.md) for an InnoDB [fulltext index](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/full-text-indexes.md). Setting either the [innodb\_ft\_server\_stopword\_table](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md) or the [innodb\_ft\_user\_stopword\_table](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md) system variable will override this. |

## Example

```sql
SELECT * FROM information_schema.INNODB_FT_DEFAULT_STOPWORD\G
*************************** 1. row ***************************
value: a
*************************** 2. row ***************************
value: about
*************************** 3. row ***************************
value: an
*************************** 4. row ***************************
value: are
...
*************************** 36. row ***************************
value: www
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}