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
1378030
2.1.8 Comandos generales de alta y baja de DBMS
Description
ADMON SMBD Mind Map on 2.1.8 Comandos generales de alta y baja de DBMS, created by maria gonzalez5024 on 30/09/2014.
No tags specified
admon smbd
Mind Map by
maria gonzalez5024
, updated more than 1 year ago
More
Less
Created by
maria gonzalez5024
over 9 years ago
1960
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
GRE Prep - Reading Comprehension
Abood
A2 Level OCR: Communication & Homeostasis
Ollie O'Keeffe
Plastics
fampulli
EBW: Onderwerp 1, Gr7 (KABV)
mvloch
med chem 2 final exam
lola_smily
Biology Unit 1a - GCSE - AQA
RosettaStoneDecoded
“In gaining knowledge, each area of knowledge uses a network of ways of knowing.” Discuss this statement with reference to two areas of knowledge_1
shobha nayar pan
chemsitry as level topic 5 moles and equations
Talya Hambling
LOVE AND RELATIONSHIPS~ AQA POETRY ANTHOLOGY
Fozia Xx
Family in the park
Eleuterio Caicedo Valencia
House of Cards
Maryse VINCENT
Browse Library