Archives of the TeradataForum

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

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

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>>