Archives of the TeradataForum

Message Posted: Fri, 14 Mar 2008 @ 20:32:02 GMT

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

Kishore:

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.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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