Re: [SQL] changing numeric into int

2002-11-08 Thread Robert Treat
There is no way to do this short of maybe hacking at the system tables, and even then thats likely to cause problems. If you cant recreate the table, your best bet is to create two new columns and copy the data in, delete the data from the old columns, rename the columns accordingly, and perhaps ad

[SQL] changing numeric into int

2002-11-07 Thread Huub
Hi, I want to change 2 columns in the same table from numeric into int. Can I do this without deleting the old table and creating a new one? Data stays the same.. Thanks Huub ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?