Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 14 Mar 2008 @ 20:32:02 GMT


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


Subj:   Re: Error 5788: creating table from View structure
 
From:   Michael Larkins

Kishore:

I am not sure if you are giving us the actual create statement or some contrived version of it because I doubt you want an empty table. However, if you are truly attempting to create an empty table to receive rows later on, you could do the following and it will work:

     Create table EmployeeDetails as
         ( SELECT 0 (int) id
                , deptid
                , empname
                , deptname
             FROM
                 "SQL00"."vwemployee"
         ) with no data Primary index PK_EmployeeDetails (Id);

Hope this helps.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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