I am trying to rename a table in a database. The table name is Message_Log and has about 300 Million records. This table has one clustered index and 5 non-clustered indexes. I want to rename it to Message_Log_200611. Then I create a new table with name Message_Log. Will this affect the indexes in old Message_Log table? Will the process takes long time to finish?
Ok. May I know will the indexes in old Message_Log table be corrupted if i change the table name to Message_Log_200611? Will the process of renaming the table with 300 million records take long time to finish in 3 Giga hertzs processing speed server with 2 Giga byte RAM memory?