Fórum Buscar campos de uma tabela #56534

SQL Server:

SELECT name FROM dbo.syscolumns 
where id = (SELECT id FROM dbo.sysobjects WHERE name = ´ACERVO´)
and name <> ´CODIGO´

Oracle:

select cols.column_name as name
from user_tab_columns cols
where cols.table_name = ´ACERVO´
and cols.column_name <> ´CODIGO´