null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
2378667
2.1.8 Comandos generales de alta y baja de DBMS
Description
Mind Map on 2.1.8 Comandos generales de alta y baja de DBMS, created by netwo03 on 26/03/2015.
Mind Map by
netwo03
, updated more than 1 year ago
More
Less
Created by
maria gonzalez5024
over 9 years ago
Copied by
netwo03
over 9 years ago
1
0
0
Resource summary
2.1.8 Comandos generales de alta y baja de DBMS
(DROP) Eliminación
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];
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;
SHOW TABLES SHOW CREATE TABLE
Eliminar una llave foranea
ALTER TABLE automovil DROP FOREIGN KEY FK_Propietario;
Show full summary
Hide full summary
Want to create your own
Mind Maps
for
free
with GoConqr?
Learn more
.
Similar
'The Merchant of Venice' - William Shakespeare
cian.buckley
The Great Gatsby - Theme
Heather Taylor
Religious Studies - Keywords.
Ready2learn
World at Risk: Disaster hotspots - the Philippines
Holly Lovering
Geography Coasts Questions
becky_e
IB Biology Topic 4 Genetics (SL)
R S
GCSE Computing : OCR Computing Course Revision
RoryOMoore
Chemistry Rates of Reaction Revision
11mzroser
Dr Jekyll and Mr Hyde THEMES
deanakentish
Management 1. PT (3MA101) - 1. část
Vendula Tranová
New PSBD/PSCOD/ASSD Edition 2018
David Thapa
Browse Library