selecting fields and data type

[pickle]

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

[Failte]

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;