Charlie Look at Sys_Views.. The column names are all stored together in sys_column_list.
Dawn Charles Parks <[EMAIL PROTECTED]> wrote on 02/20/2008 01:42:26 PM: > 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.
