selecting fields and data type
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: selecting fields and data type

  1. #1
    Join Date
    Mar 2002
    Posts
    14

    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

  2. #2
    Join Date
    Nov 2002
    Posts
    3
    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;
    Failte
    PDP Data Solutions

    It is very hard to make a good impression when your only crotch high.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width