Archives of the TeradataForum

Message Posted: Wed, 05 Mar 2008 @ 11:13:49 GMT

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

Kishore,

There are different ways to create table from already existing table

1. Create table VWPRODUCT_LEAF as (select * from vwproduct_leaf_rl) with no data ;

This will create a table with first column as NUPI.

2. Create table VWPRODUCT_LEAF as vwproduct_leaf_rl with no data ;

This will create a table with the same index definition as Source table

This approach wont work for you , as you are referring the view(vwproduct_leaf_rl), for this approach refer the base table.

3. Create table VWPRODUCT_LEAF as (select * from vwproduct_leaf_rl) with no data primary index (item_id,X,Y);

This is another way to create table defining the Indexes explicitly.

I think this is what you are looking for

Hope this helps

Thanks,

Rahul

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