DBMS: Informix.
I have a sample_tbl table with 5 3 fields that:
- user_id
- user_name,
- user_email
Now I want to add the following fields to sample_tbl with one single query to add columns. New fields:
- user_phone_no,
- USER_LOCATION,
- user_password
I want to add user_phone_no after user_id, and I want to add user_location, user_password after user_email field and all with one request. Any suggestion for this?
source
share