29.Create a New Schema and Change Schema Name Of Table In SQL
In this video, I'm going to create a new schema and create a new table with that schema.
How to Transfer from the old schema dbo to the new Schema name
Script:
SELECT * FROM sys.schemas
create schema demo
go
create table demo.SchemaTable
(
id int,
Name varchar(200)
)
alter schema demo transfer dbo.multilingual
