Create a new schema and move a table on the dbo schema to the new schema.
create schema MySchema
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