CREATE SQL SERVER SCHEMA

-------------------------------------------------------
CREATE SCHEMA Testing AUTHORIZATION dbo;
GO
CREATE SCHEMA TestingSP AUTHORIZATION dbo;

-------------------------------------------------------
CREATE LOGIN Testing
WITH PASSWORD = 'Testing@123';
USE MarketShiksha;
CREATE USER Testing FOR LOGIN Testing;
GO
---------------------------------------------------------
ALTER SCHEMA

SELECT 'ALTER SCHEMA Testing TRANSFER ' + SCHEMA_NAME(o.[schema_id]) + '.' + o.[name]
FROM sys.objects o WHERE o.[type] = 'U';
-------------------------------------------------------------------