# Viewing The DDL That Created The Table

+ `SHOW CREATE TABLE {table_name}`
+ Hint `/*T! ... */` shows the TiDB specific features, for example:
  + `AUTO_RANDOM`
  + `CLUSTERED`
  + `AUTO_RANDOM_BASE`

```
tidb> ~!@SHOW CREATE TABLE@!~ universe.stars\G
*************************** 1. row ***************************
       Table: stars
Create Table: CREATE TABLE `stars` (
  `id` bigint(20) NOT NULL ~!@/*T![auto_rand] AUTO_RANDOM(5) */@!~,
  `name` char(20) NOT NULL DEFAULT '',
  `mass` float NOT NULL DEFAULT '0.0' COMMENT '10**24 kg',
  `density` int(11) NOT NULL DEFAULT '0' COMMENT 'kg/m**3',
  `gravity` decimal(20,4) NOT NULL DEFAULT '0.0' COMMENT 'm/s**2',
  `escape_velocity` decimal(8,1) DEFAULT NULL COMMENT 'km/s',
  `mass_conversion_rate` int(11) DEFAULT NULL COMMENT '10**6 kg/s',
  `spectral_type` char(8) NOT NULL DEFAULT '',
  `distance_from_earth` float DEFAULT NULL COMMENT 'light year',
  `discover_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) ~!@/*T![clustered_index] CLUSTERED */@!~,
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ~!@/*T![auto_rand_base] AUTO_RANDOM_BASE=134447 */@!~
1 row in set (0.00 sec)
```

------------------------------------------------------------
- The `SHOW CREATE TABLE` statement shows the exact statement that created the specified table.
- This allows you to observe attributes and options that are not explicitly declared when the table is created, but are actually in effect.
- Some TiDB specific table and column options can be obsersed by this way. For example, pay attention to the `/*T! */` hints.