Subject | RE: [firebird-support] Metadata about views |
---|---|
Author | Svein Erling Tysvær |
Post date | 2014-04-07T10:04:02Z |
>Maybe, I've completly mistaken the original question, but isn'tSure, it would in many cases return the query used in the view (I think it is possible to delete the RDB$VIEW_SOURCE and still have a working view, though that is rarely desirable and probably not something Łukasz has to worry about), but it doesn't return FieldNames as defined in
>
>select
> r.RDB$VIEW_SOURCE
>from RDB$RELATIONS r
>where r.RDB$VIEW_SOURCE is not null
>
>simply returning the underlying query - with every field?
CREATE VIEW [ViewName]([FieldNames]) AS ...
just whatever is after AS.
Set