RE: Modify the name of the table

No, there's no ODBC API that will do this. You'll need to call:

sp_rename 'current_table_name' , 'new_table_name'



--------------------
| From: "Roberto Carcione" <roberto674@xxxxxxxxxxx>
| Subject: Modify the name of the table
| Date: Mon, 31 Oct 2005 15:39:02 +0100
| Lines: 11
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
| X-Antivirus: avast! (VPS 0544-0, 31/10/2005), Outbound message
| X-Antivirus-Status: Clean
| Message-ID: <#Ljh0hi3FHA.3628@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: h213-255-100-220.albacom.net 213.255.100.220
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2989
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| Hi at all,
|
| I have a database on a sqlserver 7.0. I access to it via odbc api. So i
need
| t change the name od a table. Is there a way via SQL* api functions to
| change the name of a table?
|
| thnaks
|
| roberto
|
|
|

.

Loading