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: )

5,048 reads

Blogs

App-Consistent MongoDB Snapshots Across Multiple Pure Storage FlashArrays

By

Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...

PASS: Quantum Computing Slides

By

If you're an attendee at the PASS Data Community Summit this year, there are...

A New Word: Dead Reckoning

By

dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...

Read the latest Blogs

Forums

Filtered Indexes: The Developer’s Secret Weapon in SQL Server

By Chandan Shukla

Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...

Is Data Modeling Common?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data Modeling Common?

Getting The Database Name

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting The Database Name

Visit the forum

Question of the Day

Getting The Database Name

I run this code to connect to SQL Server 2022 from the command line.

sqlcmd -S localhost -E
At the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME()
GO
What is returned?

See possible answers