删除表tb_goods中的字段picture
A: alter table tb_goods add picture;
B: alter table tb_goods drop picture;
C: alter table tb_goods rename picture;
D: alter table tb_goods modify picture;
A: alter table tb_goods add picture;
B: alter table tb_goods drop picture;
C: alter table tb_goods rename picture;
D: alter table tb_goods modify picture;
举一反三
- -- 5.删除“tb_goods”表中的“picture”字段
- 将tb_goods表中的picture字段删除：
- 删除表tb_goods的命令是 A: drop table tg_goods; B: delete table tb_goods; C: drop index tg_goods; D: delete index tb_goods;
- 为salerecord表GID字段添加外键，引用goods表中GID字段。 A: ALTER TABLE salerecord ADD CONSTRAINT pk2 PRIMARY KEY(GID) REFERENCES goods(GID); B: ALTER TABLE salerecord ADD CONSTRAINT fk2 FOREIGN KEY(GID) REFERENCES goods(GID); C: ALTER TABLE salerecord ADD CONSTRAINT fk2 FOREIGN KEY(CID) REFERENCES goods(CID); D: ALTER TABLE salerecord ADD CONSTRAINT pk2 PRIMARY KEY(CID) REFERENCES goods(CID);
- 删除表tb_goods的命令是 A: drop table tg_goods; B: delete table goods1;