selecting fields and data type

Is there any sql statement that enables me to view the field name and the data type that it accepts?
Thanks

Of course this will vary with DBMS but the describe command might be what you are looking for. This works for Oracle (7, 8, 9 I believe all supprt this) and MySQL. Not sure about SQL Server.

syntax:
desc table_name;