Wednesday, February 20, 2019

Create a new schema and move a table on the dbo schema to the new schema.

  1. create schema MySchema
  2. alter schema MySchema transfer [dbo].[MyTable]

If you have enough tables it can help to break them up by schema for readability shake. Also, you may assign permissions/security at the schema level. Yay for T-SQL!

No comments:

Post a Comment