Moving a Default Schema

Question

Moving a Default Schema

Steve Jones - SSC Editor

SSC Guru

Points: 738347
More actions
December 13, 2019 at 12:00 am

#3695995

Comments posted to this topic are about the item Moving a Default Schema

Viewing 4 posts - 1 through 4 (of 4 total)

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

Stewart "Arturius" Campbell SSC Guru Points: 72745 More actions · Answer 1

Nice question to end the week on, thanks Steve

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

webrunner SSC-Dedicated Points: 32020 More actions · Answer 2

Thanks for the instructive question, Steve!

Schemas will be my undoing lol.

-- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Steve Jones - SSC Editor SSC Guru Points: 738347 More actions · Answer 3

I've rarely done much work with them, so I find these tips and tricks interesting. There is a lot of value in using schemas for various separation items, like auditing, etc.

Moving a Default Schema

Cookies on SQLServerCentral