Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Xerxes
Aged Yak Warrior
666 Posts |
 Posted - 2005-03-07 : 15:55:06
|
I cannot find anything on this, so I'm asking: What is the simplest way to RENAME a table?Semper fi, XERXES, USMC(Ret.)------------------------------------------------------The Marine Corps taught me everything but SQL! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-07 : 15:56:07
|
| sp_rename will do the trick. Let me know if you need help with that.Tara |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-03-07 : 16:32:58
|
| Right-click on the table in Enterprise Manager, click Rename, and type in the new name.orHighlight the table in Enterprise Manager, hit the F2 key, and type in the new name.CODO ERGO SUM |
|
|
|
Xerxes
Aged Yak Warrior
666 Posts |
Posted - 2005-03-08 : 09:43:28
|
quote:
Originally posted by Michael Valentine Jones
Right-click on the table in Enterprise Manager, click Rename, and type in the new name.orHighlight the table in Enterprise Manager, hit the F2 key, and type in the new name.Michael, Uh, I KNOW that already ....I'm looking to do a rename code-wise, so that it can be executed within the SQL Task element in my DTS. CODO ERGO SUM
Semper fi, XERXES, USMC(Ret.)------------------------------------------------------The Marine Corps taught me everything but SQL! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-03-08 : 09:49:46
|
OK, but what you asked was "What is the simplest way to RENAME a table?" Just trying to be helpful.quote:
Originally posted by Xerxes
quote:
Originally posted by Michael Valentine Jones
Right-click on the table in Enterprise Manager, click Rename, and type in the new name.orHighlight the table in Enterprise Manager, hit the F2 key, and type in the new name.Michael, Uh, I KNOW that already....I'm looking to do a rename code-wise, so that it can be executed within the SQL Task element in my DTS.CODO ERGO SUM
Semper fi, XERXES, USMC(Ret.)------------------------------------------------------The Marine Corps taught me everything but SQL!
CODO ERGO SUM |
|
|
|
Xerxes
Aged Yak Warrior
666 Posts |
Posted - 2005-03-08 : 11:40:01
|
quote:
Originally posted by Michael Valentine Jones
OK, but what you asked was "What is the simplest way to RENAME a table?" Just trying to be helpful.quote:
Originally posted by Xerxes
quote:
Originally posted by Michael Valentine Jones
Right-click on the table in Enterprise Manager, click Rename, and type in the new name.orHighlight the table in Enterprise Manager, hit the F2 key, and type in the new name.Michael, Uh, I KNOW that already....I'm looking to do a rename code-wise, so that it can be executed within the SQL Task element in my DTS.CODO ERGO SUM
Semper fi, XERXES, USMC(Ret.)------------------------------------------------------The Marine Corps taught me everything but SQL!
CODO ERGO SUM
Sorry, Mike, you're right. Uh, gotta question for ya: How do you get to be a Yak DBA Kernel? How do you change those labels?Semper fi, XERXES, USMC(Ret.)------------------------------------------------------The Marine Corps taught me everything but SQL! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-03-08 : 11:46:45
|
I really don't know, but I think one of the mods changed it.I fairly certain it was because of this:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46783quote:
Originally posted by Xerxes
quote:
Originally posted by Michael Valentine Jones
OK, but what you asked was "What is the simplest way to RENAME a table?" Just trying to be helpful.quote:
Originally posted by Xerxes
quote:
Originally posted by Michael Valentine Jones
Right-click on the table in Enterprise Manager, click Rename, and type in the new name.orHighlight the table in Enterprise Manager, hit the F2 key, and type in the new name.Michael, Uh, I KNOW that already....I'm looking to do a rename code-wise, so that it can be executed within the SQL Task element in my DTS.CODO ERGO SUM
Semper fi, XERXES, USMC(Ret.)------------------------------------------------------The Marine Corps taught me everything but SQL!
CODO ERGO SUM
Sorry, Mike, you're right. Uh, gotta question for ya: How do you get to be a Yak DBA Kernel? How do you change those labels?Semper fi, XERXES, USMC(Ret.)------------------------------------------------------The Marine Corps taught me everything but SQL!
CODO ERGO SUM |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-03-08 : 11:54:57
|
those are given by rob, merkin or graz for a witty contribution usually after one reaches 1k posts. but i know of a least 4 ppl who got it before and deserved it  Go with the flow & have fun! Else fight the flow |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-03-08 : 14:36:50
|
I guess I should feel honored on getting that, since I'm only up to about 90 posts. quote:
Originally posted by spirit1
those are given by rob, merkin or graz for a witty contribution usually after one reaches 1k posts. but i know of a least 4 ppl who got it before and deserved it Go with the flow & have fun! Else fight the flow
CODO ERGO SUM |
|
|
|
Xerxes
Aged Yak Warrior
666 Posts |
Posted - 2005-03-08 : 14:44:26
|
quote:
Originally posted by Michael Valentine Jones
I guess I should feel honored on getting that, since I'm only up to about 90 posts.quote:
Originally posted by spirit1
those are given by rob, merkin or graz for a witty contribution usually after one reaches 1k posts. but i know of a least 4 ppl who got it before and deserved it Go with the flow & have fun! Else fight the flow
CODO ERGO SUM
Really! And they made you a Colonel, too! Semper fi, XERXES, USMC(Ret.)------------------------------------------------------The Marine Corps taught me everything but SQL! |
|
|
|
|
|
|
|
|
A Table by Any Other Name