Skip to content

Instantly share code, notes, and snippets.

@malkitsingh

malkitsingh/renaming schema at arvixe

Created August 26, 2015 15:01
Show Gist options
  • Save malkitsingh/1435316385ca0d36fea4 to your computer and use it in GitHub Desktop.
Save malkitsingh/1435316385ca0d36fea4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
renaming schema at arvixe
SELECT SUSER_NAME()
create schema dbo authorization appointmenthouseUser;
create schema my_schema_name authorization my_user;
alter user appointmenthouseUser with default_schema= dbo;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment