[Solved] View table SQL

Nocton · Post by **Nocton** » Sat Mar 05, 2016 1:27 pm

If I have a View table created from a Query, is there any way to see the SQL that created it or the query that it is/was associated with? Somehow the SQL must be 'known' to the View table otherwise it would not update correctly when data in related tables is changed.

Regards

Nocton

edit this topic's initial post · Post by **Villeroy** » Sat Mar 05, 2016 2:13 pm

Yes. But Base has no tool to make it visible. You can find the view definition in the database/script file of your Base archive.

Nocton · Post by **Nocton** » Sat Mar 05, 2016 2:19 pm

Many thanks, Villeroy, I've found it.

edit this topic's initial post · Post by **Villeroy** » Sat Mar 05, 2016 2:24 pm

Sorry, I forgot that you can query this stuff from internal system tables:

Code: Select all

SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_VIEWS"

(HSQL 1.8)

Nocton · Post by **Nocton** » Sat Mar 05, 2016 2:33 pm

Even better, thank you.

[Solved] View table SQL

[Solved] View table SQL

Re: View table SQL

Re: [Solved] View table SQL

Re: [Solved] View table SQL

Re: [Solved] View table SQL