SQL Queries

[andrewd]

Is there a list of tables that I can query with SQL?

So far I am only aware of t_object, t_connector, and t_objectFiles.

I am trying to run a query that will return a set of packages with a specific tagged value.  I found the t_object.Tagged field, but it is always 0, even if I add a tagged value to that element.

Any suggestions?

[andrewd]

Never mind.  I figured it out.

[qwerty]

See my Inside book. It might save you some work

q.

[Eve]

If you go to the search window of EA. There is a SQL page, and it offers type completion for both table and column names. Also, if you look at the Automation section of the help, most pages have at the top something like "Associated table in .EAP file     t_clients"