RE: Ok, where is it?

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: Raul A Jager
>
> Using SQL you can do something similar to the "field reference file" The
> way to do it is to:
>
> CREATE TABLE AS (SELECT x1, x2, x3, ..., etc. FROM FLDREF) DEFINITION ONLY

This is very nice, Raul.  How about this:

CREATE TABLE AS (SELECT x1 as y1, x2, ... FROM FLDREF) DEFINITION ONLY

Is this possible (to rename the fields when you are creating the table)?

Joe