1378030
Description
Mind Map by maria gonzalez5024, updated more than 1 year ago
|
Created by maria gonzalez5024
over 9 years ago
|
|
2.1.8 Comandos generales de alta y baja de DBMS
- (DROP) Eliminación
- DROP TABLE nombre_tabla [CASCADE CONSTRAINTS][PURGE]
- DROP TABLE nombre_tabla [CASCADE CONSTRAINTS][PURGE]
- Modificación
- ALTER TABLE [esquema.]tabla
clausula_constraint [,…]
[ENABLE clausula_activa |
DISABLE clausula_disable]
[{ENABLE|DISABLE} TABLE
LOCK] [{ENABLE|DISABLE} ALL
TRIGGERS];
- ALTER TABLE [esquema.]tabla
clausula_constraint [,…]
[ENABLE clausula_activa |
DISABLE clausula_disable]
[{ENABLE|DISABLE} TABLE
LOCK] [{ENABLE|DISABLE} ALL
TRIGGERS];
- ADD NOT NULL solo sera posible si la
tabla esta vacia MODIFI NOT NULL solo
se podra modificazr siempre y cuando
- Comando Describe
- DESCRIBE f1;
- DESCRIBE f1;
- SHOW TABLES
SHOW CREATE TABLE
- Eliminar una llave foranea
- ALTER TABLE automovil
DROP FOREIGN KEY
FK_Propietario;
- ALTER TABLE automovil
DROP FOREIGN KEY
FK_Propietario;
Want to create your own Mind Maps for free with GoConqr? Learn more.