Subject Re: [firebird-support] How create Table from View?
Author Ivan Prenosil
> Subject: [firebird-support] How create Table from View?

There is no direct command for this.
You must first create table (DDL operation),
then insert data from view (DML operation).
E.g.

CREATE TABLE MyTable (X INTEGER);
COMMIT;
INSERT INTO MyTable SELECT X FROM MyView;
COMMIT;

Ivan


>

> Hello,
> Can anybody help me? I was looking for answer but common
> expression
>
> Select * into NewTable From OldView
>
> in Firebird doesnÂ’t work.









Yahoo! Groups Links