9/13/2025 3:27:49 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
|
|
|
|
Renaming a DB field?
Posted: 26 Sep 07 10:32 AM
|
I've added some custom fields to several main tables and noted an inconsistency with the naming of one particular field, and I'd like to change it so that it reflects the same name as used in SLX. From the Administrator DB Management area I cannot rename a field, but can do it directly through SQL Manager...
I've tried renaming it through the SQL Manager on my development machine and it seems to have worked fine, but I have a few questions before I'll consider doing this in production:
1) Will this have any ill effects with remote sync? I'm assuming they won't see the change properly and I should final sync the remotes, make the change then re-cut the remote DB's...
2) Is there anything else I need to do to rename the field, asides from changing it in SQL Manager and reloading my admin/client apps?
Thanks! |
|
|
|
Re: Renaming a DB field?
Posted: 26 Sep 07 11:02 AM
|
There is a SECTABLEDEFS table which contains a row for each field in the database. I believe that fields not matching a row in that table would not be able to syncronize. Maybe someone could verify this? (I'm by no means a sync expert!)
Changing field names in SQL Manager seems a little dangerous to me. The safest thing to do (which I admid would require more work on your part), would be to delete the fields in DB Manager, and re-add them with the correct name. |
|
|
|
Re: Renaming a DB field?
Posted: 26 Sep 07 1:50 PM
|
OK that gives me enough to worry about other problems this may raise. I'll create the new field, copy data over, and then delete the old field via the SLX DB Admin.
Thanks for the heads-up Jason! |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|