Archives of the TeradataForum

Message Posted: Thu, 01 Oct 2009 @ 14:11:02 GMT

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

Another (far more convoluted approach) would be

1) Consider your access rights needs given the next few steps and grant as appropriate

2) rename the table and create a view of the table with the view name being the same as the original table name - all done in a single unit of work

3) Create a second table in the desired format and populate it from the original table (or view) using INSERT SELECT

4) run a replace view to point the view at the new table

5) Drop the view and rename the new table to be the original table name - all in a single unit of work.

6) drop the original table.

Or, if this is something you need to do on a regular basis implement a view layer for all access to your data and then you can play with physical tables to your hearts content.

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