473,320 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Rename a table

Hi all,
Does any body have any idea if i rename a Table in SQL then is it's object id in terms of Sysobjects remain same or not.

I am asking because i did below in my application.

1) I rename some huge MAIN tables with another name.
2) Re creat the Main tables from the renamed tables.

Now when i am running the procedure based on MAIN tables it is taking data from Renamed tables rather than new formed MAIN tables.

does anybody have any idea???

rawat
Jun 28 '07 #1
1 1446
r035198x
13,262 8TB
Hi all,
Does any body have any idea if i rename a Table in SQL then is it's object id in terms of Sysobjects remain same or not.

I am asking because i did below in my application.

1) I rename some huge MAIN tables with another name.
2) Re creat the Main tables from the renamed tables.

Now when i am running the procedure based on MAIN tables it is taking data from Renamed tables rather than new formed MAIN tables.

does anybody have any idea???

rawat
I'm not sure if this applies here but somewhere in the MySQL manual I read something about how table changes are not imediately visible. /that means you may need to give the server some time before the changes can be visible. You may have to look into it more to see if that's what's happening here.
Jun 28 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: TroelsM | last post by:
Hi there ! I am trying to rename a column i Access Set Conn1 = Server.CreateObject("ADODB.Connection") Conn1.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &...
2
by: Paul Casner | last post by:
I have a data warehouse that is about 10 terabyte's worth of data that must be loaded once a month. I am trying to use the DB2 version 8 rename table command but I discovered when you execute this...
1
by: gaozj111 | last post by:
Hello: Now i want to rename the table schema for example: there is one table ,whose name is A.TEST,the A is the schema name, now i want to rename the A TO B. I want to get the B.TEST table.
1
by: solar | last post by:
In my subform i have controls which i want to rename but i do not want to change the real names of the fields in the tables,nor add the name to the Caption in the field of the table.Is it possible...
4
by: Dynamo | last post by:
I am trying to upload a file and then rename the file as something else. Everything worked fine unless the renamed filename already existed. So I added some extra code to check if the filename...
1
by: EricRogers | last post by:
Thanks for any help in advance! Here 5 different cmdStrings that I have tried but they all have a syntax error in it that I cannot spot: (cmdString is dimmed as a String) cmdString = "ALTER TABLE...
1
by: Carl Pearson | last post by:
Howdy, All, Was trying to modify all tables in a particular database starting with the same prefix, i.e., "tbl_". Decided I'd rather have them all start with "_tbl_" instead. Being lazy,...
3
by: aj | last post by:
DB2 LUW 8.2 FP14 Red Hat AS 2.1 Can I use SYSPROC.ALTOBJ() to simply rename a table that has complex dependencies (RI, functions, triggers, etc...)? Seems like all the logic is in there to...
1
by: cheesey_toastie | last post by:
I have a long query which I have set off and would like to stop, and rename one of the tables used. My query is due to my lack of understanding of the underlying structure of MSSQL-Server... ...
1
by: Gladiator | last post by:
Hi Team , Can some one tell me why we dont we have a DROP column or rename a column command in DB2 ? I Have a very Huge table and need to rename a column . The only option i have to do to rename...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.