How do I change db schema to dbo

by 
ALTER SCHEMA dbo TRANSFER jonathan.MovieData;

See ALTER SCHEMA.

Generalized Syntax: 

ALTER SCHEMA TargetSchema TRANSFER SourceSchema.TableName;

More Related Contents:

  1. How can I schedule a job to run a SQL query daily?
  2. Reset identity seed after deleting records in SQL Server
  3. Querying data by joining two tables in two database on different servers
  4. Single or multiple databases
  5. Unpivot with column name
  6. How can I delete using INNER JOIN with SQL Server?
  7. Convert varchar into datetime in SQL Server
  8. sql query to return differences between two tables
  9. Check if a row exists, otherwise insert
  10. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  11. How to write UPDATE SQL with Table alias in SQL Server 2008?
  12. SQL Server 2008- Get table constraints
  13. Restrict an SQL Server connection to a specific IP address
  14. Execute Dynamic Query with go in sql
  15. TransactSQL to run another TransactSQL script
  16. Conditional logic in PostDeployment.sql script using SQLCMD
  17. How can I get a list of element names from an XML value in SQL Server
  18. Why are logical reads for windowed aggregate functions so high?
  19. How to sum up time field in SQL Server
  20. How to rename something in SQL Server that has square brackets in the name?
  21. Comma Separated values with SQL Query
  22. how to separate string into different columns?
  23. Using SQL Server as a DB queue with multiple clients
  24. How to subtract 30 days from the current date using SQL Server
  25. Count records for every month in a year
  26. SQL Server: +(unary) operator on non-numeric Strings
  27. Use one CTE many times
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment