Moving a Table

Question

Moving a Table

Steve Jones - SSC Editor

SSC Guru

Points: 734434
More actions
August 13, 2019 at 12:00 am

#3668385

Comments posted to this topic are about the item Moving a Table

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003859 More actions · Answer 1

I've never had to do such a thing before and so I have to admit that I had to look this one up. Learned something new. Thanks for the great question, Steve.

--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)

tsalha SSC Journeyman Points: 81 More actions · Answer 2

it is especially useful, if you need a table to be online all the time, but want to load lots of data to it (e.g. full reload). Then you can create it in a, say 'temp' schema. When finished, just swap the tables using the aforementioned command 😀

Jeff Moden SSC Guru Points: 1003859 More actions · Answer 3

tsalha wrote:

it is especially useful, if you need a table to be online all the time, but want to load lots of data to it (e.g. full reload). Then you can create it in a, say 'temp' schema. When finished, just swap the tables using the aforementioned command 😀

That would work as a "3 name" swap. Not sure how you'd do it with only 2 names. Repointing a synonym is seems easier.

Of course, I could be wrong and would love to see a coded example of how you do it. Even an old dog like me still likes learning different tricks.

--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)

Stewart "Arturius" Campbell SSC Guru Points: 72497 More actions · Answer 4

Nice question, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

sendijunk SSChasing Mays Points: 611 More actions · Answer 5

Why does the link point to the Brazilian documentation?

Marcia J SSCertifiable Points: 5649 More actions · Answer 6

Marcia J

SSCertifiable

Points: 5649

August 15, 2019 at 8:45 pm

#3671694

To see if anyone is paying attention.

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 7

No idea why Brazil came up for docs. I was sure I copy/pasted the US-EN version. It's been corrected.