命令
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,
可以看到主鍵信息
CONSTRAINT pk_game_host_year_event_code_athlete_code PRIMARY KEY (host_year, event_code, athlete_code),
換個體位看索引 ,利用主鍵
SELECT * FROM db_index WHERE class_name = 'game' AND is_primary_key = 'YES';