change names on the tables

• Krasavita

  SSC-Insane

  Points: 23138

  More actions

  August 28, 2011 at 9:23 pm

  #242289

  Hi,

  I need to change naming on tabels for 50 is anyone can recomend me a quick way to do it?

• Jeff Moden

  SSC Guru

  Points: 1004365

  More actions

  August 28, 2011 at 9:37 pm

  #1374364

  Unless there's a pattern to the names, no.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Krasavita

  SSC-Insane

  Points: 23138

  More actions

  August 28, 2011 at 9:44 pm

  #1374365

  Thank you

• ramdas.mutkule

  Grasshopper

  Points: 17

  More actions

  August 29, 2011 at 1:43 am

  #1374393

  Yes we can change it

  Your Question is change of name of table

  Ans :- Query

  SP_RENAME 'OLD TABLE ','NEW TABLENAME'

• Krasavita

  SSC-Insane

  Points: 23138

  More actions

  August 29, 2011 at 4:37 am

  #1374434

  Thank you