Is there any sql statement that enables me to view the field name and the data type that it accepts?
Thanks
Printable View
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;