Theredirect table contains for each page that is currently aredirect (i.e., not for old revisions which are redirects) the ID of the source page and the information about target.The target page may or may not exist.

A target is broken into four parts: interwiki prefix (should be empty for a regular redirect), namespace, title and fragment.

Contains thepage_id of the source page.

Contains the number of the target'sNamespace.

Contains the sanitized title of the target page.It is stored as text, with spaces replaced by underscores.

This field is not empty only if aninterwiki prefix is used: #REDIRECT [[prefix:…]] (a prefix such as "w:" for Wikipedia, or aninterlanguage link prefix such as "nl:" for Dutch, but not both).In this case a redirect is not visible in Special:WhatLinksHere (even if the target lies in the same wiki),rd_namespace is always 0 andrd_title may contain a possible namespace prefix, butrd_fragment may be non-NULL.

Containsthe target's fragment ID if present (see alsobugzilla:218), otherwise is NULL.

DESCRIBEredirect;

+--------------+------------------+------+-----+---------+-------+| Field        | Type             | Null | Key | Default | Extra |+--------------+------------------+------+-----+---------+-------+| rd_from      | int(10) unsigned | NO   | PRI | 0       |       || rd_namespace | int(11)          | NO   | MUL | 0       |       || rd_title     | varbinary(255)   | NO   |     |         |       || rd_interwiki | varbinary(32)    | YES  |     | NULL    |       || rd_fragment  | varbinary(255)   | YES  |     | NULL    |       |+--------------+------------------+------+-----+---------+-------+

DESCRIBEredirect;

+--------------+---------------------+------+-----+---------+-------+| Field        | Type                | Null | Key | Default | Extra |+--------------+---------------------+------+-----+---------+-------+| rd_from      | int(10) unsigned    | NO   | PRI | 0       |       || rd_namespace | int(11)             | NO   | MUL | 0       |       || rd_title     | varchar(255) binary | NO   |     | NULL    |       |+--------------+---------------------+------+-----+---------+-------+

DESCRIBEredirect;

+--------------+---------------------+------+-----+---------+-------+| Field        | Type                | Null | Key | Default | Extra |+--------------+---------------------+------+-----+---------+-------+| rd_from      | int(8) unsigned     | NO   | PRI | 0       |       || rd_namespace | int(11)             | NO   | MUL | 0       |       || rd_title     | varchar(255) binary | NO   |     | NULL    |       |+--------------+---------------------+------+-----+---------+-------+

SHOWINDEXINredirect;

+----------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| Table    | Non_unique | Key_name    | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |+----------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| redirect |          0 | PRIMARY     |            1 | rd_from      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               || redirect |          1 | rd_ns_title |            1 | rd_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               || redirect |          1 | rd_ns_title |            2 | rd_title     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               || redirect |          1 | rd_ns_title |            3 | rd_from      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |+----------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

• MediaWiki database tables
• Redirect