Archives of the TeradataForum

Message Posted: Tue, 25 Mar 2014 @ 12:09:29 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Add new columns in a existing table after

From:		Dieter Noeth

Anomy.Anom wrote:

Can I add a new column in existing Teradata table after a particular existing column.

No, you can't. It's a relational database :)

I don't want to drop and re-create the table with new columns

     REPLACE VIEW myRearrangedTable AS
     SELECT all columns in particular order
     FROM oldTable;

Dieter


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2014 Indexes

Last Modified: 15 Jun 2023