ALTER TABLE my_table_name ADD my_column_name Varchar(30) default 'Not Processed' NOT NULL;
----
Changing the length of the email field varchar to 45 (In the users table).
ALTER TABLE users ALTER COLUMN email_address TYPE VarChar(45);
ALTER TABLE my_table_name ADD my_column_name Varchar(30) default 'Not Processed' NOT NULL;
No comments:
Post a Comment