I have a Sybase SQL Server 10, running on a Sparc Solaris 2.6.
I have a couple of tables that share a user datatype, TableId which is a smallint.
We have reached 32600 odd, and will soon run out of id's.
I have defncopied and bcp'd the data out,
recreated the table with a different datatype, ItemId
which is an int. Now the interesting bit........
When I update the id of my new table to what my old table was,
Sybase can no longer see it, and the shell for my isql session hangs if I try to access the table.
How do I recreate this table with a bigger datatype and retain its old id?
Are there any other tables I have to update aswell?