Re: Change columns datatype and order

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Mon, 27 Jun 2005 16:56:10 +0000 (UTC)
Message-ID: <d9pb39$p18$1@klatschtante.init7.net>

On 2005-06-27, Ach C via DBMonster.com <forum_at_DBMonster.com> wrote:
> 1.How to change a columns data type without making that column empty?

Others have already answered this question

> 2.How to change the order of columns in a table?
> for the 2nd one,I know I can create a new table and do "select into" and...
> but I am curious about another way! ;)

create view some_table_v as (
  select

    col_3,
    col_2,
    col_1

  from
    some_table;

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/

Received on Mon Jun 27 2005 - 11:56:10 CDT