| SQL Server - Get table storage and row count for all tables >>

SQL Server - Move tables between schemas

by Administrator 23. September 2009 22:45

Ever needed to move or transfer tables or stored procedures (and presumably other database objects) from one schema to another? Then this is the command you need.

ALTER SCHEMA DestinationSchema TRANSFER SourceSchema.ObjectToMove

Tags: sqlserver sql server 2008 move transfer table between schema

SQL Server Statements

SQL Server - Move TempDb Log File[code:tsql] ALTER DATABASE TempDB MODIFY FILE(NAME = templog, FILENAME = 't:\templog.ldf') [/code]...SQL Server - Get table storage and row count for all tablesThis simple script returns a list of tables, their row counts and storage usage [code:tsql] DECLAR...SQL Server - Send Email Using Database Mail From TSQL or Stored ProcedurePretty simple stuff. This assumes that a valid database account etc. is set up and Database Mail is ...

Buy Me a Beer ?

If you've found this site useful, you could help support its running costs by either checking out the adverts on the page if you find anything that interests you - or by making a small donation

Blog Entries

Useful Web Pages

SQL Server - Move tables between schemas