schema-only

Technical Article

How to Move a Table into a Schema in T-SQL

  • Script

To move a table into a schema in T-SQL, you can use the ALTER SCHEMA statement along with the TRANSFER option. Here are the steps to do this: Assuming you have an existing schema named "NewSchema" and a table named "YourTable" that you want to move into this schema: Open SQL Server Management Studio or […]

You rated this post out of 5. Change rating

2023-09-29 (first published: )

3,289 reads

Blogs

Plan Time for Self-Development

By

As you begin the new year, if you don't already have time set aside...

BK’s Bookshelf: Never Split the Difference

By

I picked up Never Split the Difference: Negotiating As If Your Life Depended On...

Replacing Images in PBIR Format Reports

By

With the PBIR format of Power BI reports, it’s much easier to make report...

Read the latest Blogs

Forums

how to fix this error?

By water490

hi I am creating a stored procedure to reduce log size when needed.  I...

The Oldest Article

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Oldest Article

Happy New Year 2025

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Happy New Year 2025

Visit the forum

Question of the Day

The Oldest Article

What's the oldest article on SQL Server Central (take a guess)?

See possible answers