What is the correct syntax to find column names that are in a view? I tried: SELECT Sys_Column_Name FROM Sys_Columns t1, Sys_Tables t2 WHERE t1.SYS_TABLE_ID = t2.SYS_TABLE_ID and sys_table_name = 'tvCompanyContact'
but get <WARNING> No rows exist or satisfy the specified clause. (2059) tvCompanyContact is a valid view in the database and does have data when I try to browse it.

