What is similar in mssql to $dbh->listfields($tbl) in mysql

PugSA has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks

I was recently told to move my MySql db's to MSSQL

I know very little of MSSQL and hope you can help me

1. I use a Mysql module and it has a 'listfields' function to return the column names, do you know of anything similar in MSSQL

Thank you