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