Skip to content

Opening book details…

Can I read SQL ALTER TABLE: Add/Drop Columns & Keys on EtoBox?

SQL ALTER TABLE: Add/Drop Columns & Keys by crazz1 is a document available to read on EtoBox.

What is SQL ALTER TABLE: Add/Drop Columns & Keys about?

The document discusses various SQL ALTER TABLE commands: - ADD/DROP COLUMN commands can add or remove columns from a table. MODIFY can change column properties. - ADD/DROP PRIMARY KEY commands can add or remove a primary key constraint to a table column or set of columns. - ADD/DROP FOREIGN KEY commands can add or remove a foreign key constraint linking two tables. - DROP TABLE completely removes a table and its data. TRUNCATE TABLE deletes all rows from a table. - INDEX creates an index on one or more co

Author
crazz1
Language
EN