rename a table in asp

[certify]

can anyone show me how to rename a table in asp using sql statement....

thanks

[certify]

the table i'm refering here is a database table.... ok....

[dhtmlgod]

I had a quick look about, and I couldn't find anything about it, so I'm not sure if you can.

[shane]

Not sure about Access but with SQL Server you can use the stored procedure sp_rename. I think it can be used with any object (ie table, sp, view constraint etc).


sp_rename oldname, newname

[Jeremy W.]

Don't think you can simply rename a table...

However you could create a table, replicate the data then drop it...

However I'll ask my compadre in crime

[ccweng]

hmmmm....... create a table and then drop the old table..... but in sql.... there is a command called rename.....

rename table old-table to new-table........ also

alter table old-table
rename new-table

but.... i don't know this will work or not....

thanks....

[Jeremy W.]

the rename thing is NOT a standard SQL command (for tables)... sp_rename works in SQL Server, RENAME works in Oracle, etc.

[goober]

I believe explainations are needed?

Examples help too.

[Jeremy W.]

Okay, SQL is Standard Query Language.

Problem is, it's not necessarily standard, the larger Database engines (RDBMS's) each have "extended" SQL commands.

In SQL Server one of these is sp_rename.

That good enough? *L*

[dhtmlgod]

Uhm... doesn't SQL stand for Structured Query Language?

[ccweng]

doesn't sql has its own command for renaming a table.... i mean the standard one, since it can create table, alter table....

why can't rename the table? just puzzled.....

[dhtmlgod]

Why exactly do you want to rename a table anyway?

[Jeremy W.]

Whoops... Structured *L* :shame:

[certify]

u know... it is good to know new things... u can shorten some codes by just using some commands that u didn't know it exist...