Use the POSITION option
---------------------------

----- Original Message -----
From: "Kevin Morris" <kmorris5319@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, November 05, 2002 5:44 PM
Subject: [ib-support] Add a column after a specific field on existing tables


| 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
|
|
|
| To unsubscribe from this group, send an email to:
| ib-support-unsubscribe@egroups.com
|
|
|
| Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|
|
|