Modify DBMS table structure (add additional column)?

[kevin...@gmail.com]

I have an existing table in a SQL db that I have a linked connection to.  Need to make some table changes, specifically adding a new column or two to the table.

Usually it would be simple as Table>Modify Structure and then add a field.  Unfortunately when I select the linked table the modify table structure window that opens does not have the add/remove field option like usual. The window simply has field name and types and checkboxes to make indexes.

Any ideas?

Thanks,
Kevin

[Peter Horne]

Hi Kevin,

Pretty sure you can't alter the table structure in MAPINFO for a linked tabled. Modification needs to be done to the DB table in the DB, then you will need to recreate your MI tab to include the new columns.

thanks Peter H

[Cinda Graubard]

You need to modify the table structure inside the SQL db and then remake that linked table.

Cinda Graubard

GeoMax

--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/15dd368d-4ea8-4899-9806-1e2fcf96f765n%40googlegroups.com.