Results 1 to 4 of 4

Thread: Deleting Tables

  1. May 31st, 2000, 05:00 AM #1
    PITBULLCJR
    PITBULLCJR is offline

    Thread Starter
    Hyperactive Member PITBULLCJR's Avatar
    Join Date
    Nov 1999
    Location
    New York
    Posts
    408

    Unhappy

    Is there any way to delete a table? If there is please let me know and maybe tryt o explain it a little bit for me thanks!!
    Sincerely,
    Chris


    Email: [email protected]
    AIM: KnightsOfTheMoon
    WebPage: http://kom.wicre.com
    ----------------
    VB6 Professional
    Abit ST6-RAID
    1000 MHZ
    512 MB PC133 Ram
    Nvidia GeForce 2 Ultra 64 MB
    Maxtor 81.9 Gig
    Win 98 SE
    Reply With Quote Reply With Quote
  2. May 31st, 2000, 01:15 PM #2
    Clunietp
    Clunietp is offline
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    what database?
    Reply With Quote Reply With Quote
  3. May 31st, 2000, 01:27 PM #3
    JasonGS
    JasonGS is offline
    Addicted Member JasonGS's Avatar
    Join Date
    May 2000
    Location
    California
    Posts
    155
    You can do it with the SQL statement "DROP TABLE Table1", ADO example...
    Code:
    Dim adoConn As New ADODB.Connection
' Assuming a connection is made to your DB here...
adoConn.Execute "DROP TABLE Table1"
    Reply With Quote Reply With Quote
  4. May 31st, 2000, 04:09 PM #4
    Chris
    Chris is offline
    PowerPoster Chris's Avatar
    Join Date
    Jan 1999
    Location
    K-PAX
    Posts
    3,238

    Lightbulb Also can apply unser DAO Object

    This DROP TABLE sql statement also can use in the DAO object.
    My Virtual Home - My Blog
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width