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