你的位置:首页 > 软件开发 > 数据库 > CUBRID学习笔记 21 查看主键外键索引

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

发布时间:2016-03-16 18:00:19
命令show create table game;game是表名 在web管理中,请在sql标签中查,不要在query中执行.show create table game;=== <Result of SELECT Command in Line 1> === T ...

命令

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. 可以看到外键信息如
CONSTRAINT fk_game_event_code FOREIGN KEY (event_code) REFERENCES event ON DELETE RESTRICT ON UPDATE RESTRICT, 换个**看索引 ,利用主键
SELECT * FROM db_index WHERE class_name = 'game' AND is_primary_key = 'YES';

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

 

 

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


原标题:CUBRID学习笔记 21 查看主键外键索引

关键词:

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

可能感兴趣文章

我的浏览记录