Differences

This shows you the differences between two versions of the page.

--- sql:alter:alter_table [2022/07/08 08:26] – created 185.92.25.31
+++ sql:alter:alter_table [2022/07/08 08:29] (current) – 185.92.25.31
@@ Line 6: / Line 6: @@
 ALTER TABLE Students
 ADD email varchar (255);
+</code>
+----
+===== Modify the datatype of an existing column =====
+<code sql>
+ALTER TABLE Students
+ALTER COLUMN email varchar (512);
+</code>
+----
+===== Remove an existing column from a table =====
+<code sql>
+ALTER TABLE Students
+DROP COLUMN email;
 </code>