Results 1 to 4 of 4

Thread: Deleting table using ADO & SQL

  1. Aug 7th, 2002, 08:43 AM #1
    jzeleznj
    jzeleznj is offline

    Thread Starter
    New Member
    Join Date
    Aug 2002
    Location
    Nedelisce, Croatia
    Posts
    2

    Post Deleting table using ADO & SQL

    Does anyone know if it is possible to delete tables using SQL queries with ADO?

    Reply With Quote Reply With Quote
  2. Aug 7th, 2002, 09:15 AM #2
    peet
    peet is offline
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    VB Code:
    1. cn.Execute "DROP TABLE Table1"

    cn = connection object
    -= a peet post =-
    Reply With Quote Reply With Quote
  3. Aug 7th, 2002, 09:25 AM #3
    kirankumar
    kirankumar is offline
    Lively Member
    Join Date
    Jun 2002
    Location
    Kuwait
    Posts
    85
    yes u can dierectly execute the drop table query as :

    connection.execute("drop table yourtablename")


    the table will be deleted.
    Your attitude determines your altitude!!!
    Reply With Quote Reply With Quote
  4. Aug 8th, 2002, 03:51 AM #4
    jzeleznj
    jzeleznj is offline

    Thread Starter
    New Member
    Join Date
    Aug 2002
    Location
    Nedelisce, Croatia
    Posts
    2
    thnx!
    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