[Solved] View table SQL

Creating tables and queries

[Solved] View table SQL

Postby 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
Last edited by Nocton on Sat Mar 05, 2016 2:17 pm, edited 1 time in total.
OpenOffice 4.2.0 on Windows 10
Nocton
Volunteer
 
Posts: 508
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: View table SQL

Postby 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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27760
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] View table SQL

Postby Nocton » Sat Mar 05, 2016 2:19 pm

Many thanks, Villeroy, I've found it.
OpenOffice 4.2.0 on Windows 10
Nocton
Volunteer
 
Posts: 508
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: [Solved] View table SQL

Postby Villeroy » Sat Mar 05, 2016 2:24 pm

Sorry, I forgot that you can query this stuff from internal system tables:
Code: Select all   Expand viewCollapse view
SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_VIEWS"

(HSQL 1.8)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27760
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] View table SQL

Postby Nocton » Sat Mar 05, 2016 2:33 pm

Even better, thank you.
OpenOffice 4.2.0 on Windows 10
Nocton
Volunteer
 
Posts: 508
Joined: Fri Nov 05, 2010 10:27 am
Location: UK


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 2 guests