Alter/Add Table Schema

Sadly, I spent 30 minutes looking for this yesterday. :(

It is plenty easy to add a table to a schema:

use databaseName

go

alter schema schemaName transfer dbo.tableName

go

Good Times!

Tags:

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>