Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    2

    Cool Unanswered: Describe command.

    Hi,

    I have some (OLD) college notes that say if I type

    Describe tablename;
    Name NOT NULL? Type

    in my SQL code window in access once run it will give me the structure of the table.

    When I try to run I get a Invalid SQL statement error 'DELETE', 'INSERT'...

    Where am I going wrong.

    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    oh, it's simple, your old notes are wrong, access doesn't support that command
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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