Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2008 @ 14:00:40 GMT


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


Subj:   Error 5788: creating table from View structure
 
From:   K Kishore

I am getting below error when creating a table from view structure.

     Create table EmployeeDetails as
        (Select * from VWEmployee)
            with no data
            Primary index PK_EmployeeDetails (Id);

     Error--> 5788: Create Table As currently
                    do not support identity columns.

Tables & view:

     Create table
         dept(id integer generated by default
                            as identity(start with 1 increment by 1) not null,
         deptname varchar(100),
         primary index (id));

     Create table
         employee(id integer generated by default
                                as identity(start with 1 increment by 1) not null,
         empname varchar(100),
         deptid integer,
         Primary index(id),
         FOREIGN KEY(deptid) REFERENCES WITH CHECK OPTION dept (id));


     Create view vwemployee
     AS
        select e.id,
               e.empname,
               deptname
           from employee e
           inner join dept d  on e.id=d.id

Please suggest me, how I can create "EmployeeDetails" table from "VWEmployee" view.


Regards,

Kishore KK



     
  <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: 27 Dec 2016