How to change schema name of the Table in SQL Like dbo to crackuser?

1.	How to change schema name of the Table in SQL Like dbo to crackuser?
Answer» How to change schema NAME of the Table in SQL Like dbo to crackuser? TO change schema name of the table we need only alter command as given below ALTER SCHEMA crackuser TRANSFER dbo.table_name There are some situation where we are not ABLE to find the schema name in SQL. SO to creat that we use below query to CREATE schema. IF (NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'crackuser')) BEGIN EXEC ('CREATE SCHEMA [crackuser] AUTHORIZATION [dbo]') END

Discussion