Re: Need to determine if a column exists or not

"news.integraonline.com" <aanderson_at_lillysoftware.com> writes:

> I am in a situation where I need to determine is a column exists in a
> database or not.
>
> Does anyone know a way to do this.
>
>

Have a look at the all_tab_columns view. You can do a select on this view to determine if a table in a specific schema has a specific column.

e.g. desc all_tab_columns

Tim Received on Thu Oct 17 2002 - 17:52:37 CDT