Results 1 to 2 of 2

Thread: How to rename the tables?

  1. Feb 15th, 2008, 03:07 PM #1
    matrik02
    matrik02 is offline

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2007
    Location
    Malaysia
    Posts
    1,370

    How to rename the tables?

    I would like to know how I can drop the table A and rename the table D to A ?


    Code:
    Set db = New ADODB.Connection
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\DBMS.mdb;Persist Security Info=False"
Set rst = New ADODB.Recordset
rst.Open "Select distinct * into D from A", db, adOpenDynamic, adLockOptimistic
    Reply With Quote Reply With Quote
  2. Feb 17th, 2008, 01:12 AM #2
    itspramod
    itspramod is offline
    Addicted Member
    Join Date
    Feb 2008
    Location
    California
    Posts
    151

    Re: How to rename the tables?

    EXEC sp_rename 'customers', 'custs'
    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