Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    drop table (Access 2000)

    I want to delete the table Customers through the command DROP TABLE "Customers" but i do not know
    how to build the command.I want to delete the table with a DROP table comand and not Delete object
    Can somebody help me?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: drop table (Access 2000)

    Is this in SQL Server or Access? Are you trying to do this in code or from the query grid.

    DROP TABLE is a data definition language construction and it doesn't take quotes around the table name. You can do it from the query grid by selecting the Query menu and choosing SQL Specific-->Data Definition. Then just type your DROP TABLE Customers in and run it. If you want to do it some other way, you're going to have to explain more about what you're trying to accomplish.
    Charlotte

Posting Permissions

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