WARNING:
JavaScript is turned OFF. None of the links on this concept map will
work until it is reactivated.
If you need help turning JavaScript On, click here.
Este Cmap, tiene informaciĆ³n relacionada con: ALTER, TABLE with RENAME Change the name of a table, CONSTRAINT removes ALTER TABLE <table> DROP CONSTRAINT <name>, ALTER TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... example ALTER TABLE Module TO Asignatura, Tabla TO Table RENAME TABLE Module TO backup_module, Asignatura TO Module, CONSTRAINT adds ALTER TABLE <table> ADD CONSTRAINT <definition of Primary Key/ Foreign Key>, COLUMN modifies ALTER TABLE <table> CHANGE [COLUMN] <old_name> <name> <new_definition> ALTER TABLE <table> MODIFY/ALTER [COLUMN] <name> <new_definition>, COLUMN adds ALTER TABLE <table> ADD COLUMN <col>, ALTER TABLE <table> ADD CONSTRAINT <definition of Primary Key/ Foreign Key> example ALTER TABLE Module ADD CONSTRAINT pk PRIMARY KEY (id), fk FOREIGN KEY (name) REFERENCES teacher (module), TABLE with ALTER ALTER TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ..., TABLE with RENAME RENAME TABLE old_table TO backup_table, new_table TO old_table;, ALTER is structured as COLUMN, RENAME TABLE old_table TO backup_table, new_table TO old_table; example ALTER TABLE Module TO Asignatura, Tabla TO Table RENAME TABLE Module TO backup_module, Asignatura TO Module, ALTER is structured as TABLE, ALTER TABLE <table> CHANGE [COLUMN] <old_name> <name> <new_definition> ALTER TABLE <table> MODIFY/ALTER [COLUMN] <name> <new_definition> example ALTER TABLE Student CHANGE Degree Grade TINYINT(2) NOT NULL ALTER TABLE Student MODIFY Degree TINYINT(2) NOT NULL, ALTER is used for Change the structure of an existing database wihout deleting it, COLUMN removes ALTER TABLE <table> DROP COLUMN <name>, DDL changing tables ALTER, ALTER TABLE <table> DROP COLUMN <name> example ALTER TABLE Student DROP COLUMN Degree, ALTER TABLE <table> DROP CONSTRAINT <name> example ALTER TABLE Module DROP CONSTRAINT ck, Change the structure of an existing database wihout deleting it as a reference http://dev.mysql.com/doc/refman/5.0/en/alter-table.html, ALTER TABLE <table> ADD COLUMN <col> example ALTER TABLE Student ADD COLUMN Degree VARCHAR(50)