2.1.8 Comandos generales de alta y baja de DBMS

maria gonzalez5024
Mind Map by maria gonzalez5024, updated more than 1 year ago
maria gonzalez5024
Created by maria gonzalez5024 over 5 years ago
782
0

Description

ADMON SMBD Mind Map on 2.1.8 Comandos generales de alta y baja de DBMS, created by maria gonzalez5024 on 09/30/2014.

Resource summary

2.1.8 Comandos generales de alta y baja de DBMS
1 (DROP) Eliminación
1.1 DROP TABLE nombre_tabla [CASCADE CONSTRAINTS][PURGE]
2 Modificación
2.1 ALTER TABLE [esquema.]tabla clausula_constraint [,…] [ENABLE clausula_activa | DISABLE clausula_disable] [{ENABLE|DISABLE} TABLE LOCK] [{ENABLE|DISABLE} ALL TRIGGERS];
3 ADD NOT NULL solo sera posible si la tabla esta vacia MODIFI NOT NULL solo se podra modificazr siempre y cuando
4 Comando Describe
4.1 DESCRIBE f1;
5 SHOW TABLES SHOW CREATE TABLE
6 Eliminar una llave foranea
6.1 ALTER TABLE automovil DROP FOREIGN KEY FK_Propietario;
Show full summary Hide full summary

Similar

Essay Writing: My Essay Plan
Andrea Leyden
Korean Grammar Basics
Eunha Seo
English Literature Key Terms
charlotteoom
CITAÇÕES DE GRANDES FILÓSOFOS
miminoma
GCSE AQA Biology - Unit 3
James Jolliffe
AS Economics Key Terms
Fred Clayton
Edexcel Additional Science Biology Topic 2- Life Processes
hchen8nrd
English Language Techniques
lewis001
OP doplnovaci otazky
Helen Phamova
seis procesos de la ARH. Administración de Recursos Humanos
Yery Takigawa Guzmán
EQUILIBRIO QUIMICO
Joel Tapia