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


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
         ) 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: 28 Jun 2020