Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Can I add composite primary key on table?
 
From:   Gadodia, RahulKumar

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023