Archives of the TeradataForum
Message Posted: Thu, 13 Mar 2008 @ 14:00:40 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|