Restructuring a table

From: Ike (rxv_at_hotmail.com)
Date: 12/19/03 

Date: Fri, 19 Dec 2003 18:42:27 GMT

Suppose I have a table, and it is populated with many rows already. However,
I realise I structured something wrong in my table. I dont want to have to
go back and repopulate the entire table.

For example, suppose I have a field:

"inoutstatus INTEGER(3),"

Which I now realize should be :

"inoutstatus CHAR(1),"

Is there a way I can change the entire table without losing the other
records in each row? I can go back in and repopulate the inoutstatus fields,
but I really would like to know if there is merely some type of SQL command
I can issue to restructure the table this way.

Thanks, Ike

Relevant Pages

  • Re: Restructuring a table
    ... I can go back in and repopulate the inoutstatus fields, ... I don't know which is your database platform, but I would quess that it ... Instead of CAST you might have you some other function which is specific ...
    (comp.lang.java.databases)
  • Re: Large dataset displayed but kills application
    ... DONT use a dataset, if you dont need all the feautures. ... >> I have a page where I input two dates, click a button that runs a query ... >> and binds it to a datagrid. ... >> is OK and I can click my button again and again and it will repopulate ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Restructuring a table
    ... I dont want to have to ... I can go back in and repopulate the inoutstatus ... Beware of conversion issues when changing ...
    (comp.lang.java.databases)
  • materialized view vs. denormalized table
    ... Whats the difference between these two? ... Dont you need to update/ repopulate them both if data in ... TIA, ChrisR ...
    (microsoft.public.sqlserver.server)
  • Re: materialized view vs. denormalized table
    ... no you would not have to repopulate ... "ChrisR" wrote in message ... > Dont you need to update/ repopulate them both if data in ... > the underlying table changes? ...
    (microsoft.public.sqlserver.server)