List columns names contained in a db

[Tecla1]

Good Afternoon,

I often need to go into DB to check the right name of column …. there is a data that show alla names of columns?

I read more document but i have not find a right refer.

Many thnks for your kindly help.

Tecla

[andreas_lds]

Depends on the sas-tool you are using and the way you access the db.

If you are using EG 8.x and a library is assigned to the db, you can use the drill down to the variable names using the library-view.

[Tecla1]

Tnks Andreas, I need to put column names in a new DB line by line.

[Kurt_Bremser]

When a SAS library for the remote DB schema is defined, the columns should appear in DICTIONARY.COLUMNS in PROC SQL.