# Primary Key And Index (Continued...)

```12
CREATE TABLE `stars` (
  `id` ~!@bigint@!~ AUTO_RANDOM,
  `name` char(20) NOT NULL DEFAULT '',
  `mass` float NOT NULL DEFAULT 0.0 COMMENT '10**24 kg',
  ...
  `distance_from_earth` float COMMENT 'light year',
  `discover_date` datetime DEFAULT NULL,
  ~!@PRIMARY KEY (`id`)@!~,
  KEY (`name`)
);

tidb> SELECT _tidb_rowid FROM universe.stars;
ERROR 1054 (42S22): ~!@Unknown column '_tidb_rowid'@!~ in 'field list'
```

------------------------------------------------------------

For table with INT like column as primary key, _tidb_rowid implicit column is not available.

```
tidb> CREATE TABLE test.dropme (
    ->   id BIGINT AUTO_RANDOM,
    ->   name CHAR(35) NOT NULL,
    ->   PRIMARY KEY (id)
    ->   );

tidb> select key_name, column_name, index_id from information_schema.tidb_indexes 
    ->    where table_schema='test' and table_name='dropme';
+----------+-------------+----------+
| key_name | column_name | index_id |
+----------+-------------+----------+
| PRIMARY  | id          |        0 |
+----------+-------------+----------+
```