table info question

[Jacob Kuntz]

I am trying to find a portable way to learn about the columns in a table.
Showing my MySQL roots, I first tried to use $dbh->prepare("SHOW FIELDS FROM
$table"). When trying to connect to MS SQL, I discovered that "show
fields..." is mysql-specific. What is the Right Way to do this?

-- 
Jacob Kuntz
Technology Director
The Real Estate Company
[EMAIL PROTECTED]