Adam Brown
Last Activity: Jul 27 '12, 01:43 PM
Joined: Dec 21 '11
Location:
-
I understand where that could be useful, unfortunatley it is the problem of being unable to rename a table that is causing the issue in the first place. -
Unfortunatley I can not adjust the front end so it needs to be the contact2 table.Leave a comment:
-
Unfortunatley it has to be a change to the table otherwise it will not get picked up by the front end.Leave a comment:
-
All very good points I knew someone would ask.
1) My company only uses Oracle databases with this one exception.
2) No, The programme was installed by an outside contractor who did not install SMS.
3) We are using GoldMine CRM, for some reason known only to Frontrange the last column of each table must be the recid column (All columns after this are ignored by the front end) in order to add a new column into the database...Leave a comment:
-
SQL Developer is an Oracle SQL Development Environment.
I am trying to change a table.
The problem is that I have a database in SQL Server which depends on having a specific column as the last column and so in order to add a new field I need to take the table and recreate it with the additional column and then drop the original table and rename it. but for some reason I can't get it to rename.Leave a comment:
-
Using SQL Developer to work on SQL Server
Good morning,
I have a SQL Server Database I am working on and only have SQL Developer to work on it and I am coming up with lots of issues to getting some basic stuff to work.
All I am really trying to do is rename a query but it simply will not work, here is what I have tried.
sp_rename 'Contact2', 'Contact4' - which gives me a command unknown error
EXEC sp_rename 'Contact3, 'Contact4'...
No activity results to display
Leave a comment: