User Tools

Site Tools


sql:alter:alter_table

SQL - ALTER - ALTER TABLE

Add a new column to a table

ALTER TABLE Students
ADD email VARCHAR (255);

Modify the datatype of an existing column

ALTER TABLE Students
ALTER COLUMN email VARCHAR (512);

Remove an existing column from a table

ALTER TABLE Students
DROP COLUMN email;
sql/alter/alter_table.txt · Last modified: 2022/07/08 08:29 by 185.92.25.31

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki