var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sybase- Query Help
What is the equivalent query in Sybase for the below query in Oracle:
SELECT table_name, column_name FROM all_tab_columns order by table_name, column_id
I am trying to display all the table and column names.
Thanks in advance
select o.name, c.name
from sysobjects o, syscolumns c
where o.id = c.id
order by o.name, c.colid
You can find all the tables in the system table sysobjects. This table contains all objects like tables, trigger, sp etc. User tables are market with U in the type field.
select name, id from sysobjects where type = 'U'
You find the columns in syscolumns.
select name from syscolumns where id = @table_id
where @table_id is the id from the first query. To get the types of the columns, join syscolumns and systypes, check the Ref Manual for more info.
Thank you so much guys...
That worked like a charm.