Trying out the new 'Database' tab and its functions.
I'm looking at a java source file that contains SQL statements. I see they're now highlighted green, which I assume means that IDEA recognizes this as "this is SQL" and I'll get the SQL code assist things? So I'm inside that string and I hit ctrl-space and I get a huge popup list of SQL keywords (ok, fine). But where's the table and column names?
As talked about here: http://www.jetbrains.com/idea/features/sql.html
Do the table/column names only come up inside *.sql files?
I've tried in that type of file as well, but I'm actually getting less joy there. No highlighting even. I must have something configured incorrectly. Any help?