Subject | Add a column after a specific field on existing tables |
---|---|
Author | Kevin Morris |
Post date | 2002-11-06T00:44:21Z |
Hi All,
Is there a way to specify the column position for a new column
added to an existing table.
I could do this in MySQL with:
ALTER TABLE <table_name> ADD <new_column_name> <datatype> AFTER
<existing_column_name>.
Thanks,
Kevin Morris
Is there a way to specify the column position for a new column
added to an existing table.
I could do this in MySQL with:
ALTER TABLE <table_name> ADD <new_column_name> <datatype> AFTER
<existing_column_name>.
Thanks,
Kevin Morris