CUBRID学习笔记 21 查看主键外键索引

命令

show create table game;

game是表名 

在web管理中,请在sql标签中查,不要在query中执行.

?

show create table game;

=== <Result of SELECT Command in Line 1> ===

  TABLE                 CREATE TABLE       

============================================

  'game'                'CREATE TABLE game (

host_year INTEGER NOT NULL, event_code INTEGER NOT NULL, athlete_code INTEGER NOT NULL,

stadium_code INTEGER NOT NULL, nation_code CHARACTER(3), medal CHARACTER(1), game_date DATE, 

CONSTRAINT pk_game_host_year_event_code_athlete_code PRIMARY KEY  (host_year, event_code, athlete_code), 

CONSTRAINT fk_game_event_code FOREIGN KEY  (event_code) REFERENCES event ON DELETE RESTRICT ON UPDATE RESTRICT, 

CONSTRAINT fk_game_athlete_code FOREIGN KEY  (athlete_code) REFERENCES athlete ON DELETE RESTRICT ON UPDATE RESTRICT)'

1 row selected.

Current transaction has been committed.

1 command(s) successfully processed.<br><br> 可以看到外键信息如

?

CONSTRAINT fk_game_event_code FOREIGN KEY  (event_code) REFERENCES event ON DELETE RESTRICT ON UPDATE RESTRICT,  <br><br><br>可以看到主键信息

?

CONSTRAINT pk_game_host_year_event_code_athlete_code PRIMARY KEY  (host_year, event_code, athlete_code),  <br><br>换个体位看索引 ,利用主键

?

SELECT * FROM db_index WHERE class_name = 'game' AND is_primary_key = 'YES';

 

 

?

<br><br><br>

?

<br><br>

?

<br><br><br><br><br><br><br><br><br><br>