修改数据表结构语句中,用于删除外键的字句是( )
A: delete primary key
B: delete foreignkey
C: drop primary key
D: drop foreign key
A: delete primary key
B: delete foreignkey
C: drop primary key
D: drop foreign key
举一反三
- 删除外键约束的语句是 ( ) 。 A: delete foreign key B: delete key FK C: drop foreign key D: drop key FK
- 为已经存在的表添加主键约束用到的关键字是()[br][/br](2.0) A: drop primary key B: add primary key C: create primary key D: show primary key
- 要删除外键,应使用哪条语句? A: ALTER TABLE B: DELETE TABLE C: ALTER FOREIGN KEY D: DELETE FOREIGN KEY
- 删除stu表,建立在sid列上的主键,可使用以下哪条命令。 A: alter table stu drop primary keys; B: alter table stu drop primary key; C: alter table stu drop primary key sid; D: alter table stu drop constraint sid;
- 在定义表结构或修改表结构时,如果定义了( )约束,可以间接创建索引 A: PRIMARY KEY或FOREIGN KEY B: UNIQUE或FOREIGN KEY C: PRIMARY KEY或UNIQUE D: UNIQUE或 DEFAULT