Answers for "update schema name in sql server"

SQL
1

change table schema sql server

USE AdventureWorks2012;  
GO  
ALTER SCHEMA HumanResources TRANSFER Person.Address;  
GO
Posted by: Guest on July-10-2020
0

alter schema sql server

IF (NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'exe')) 
BEGIN
    EXEC ('CREATE SCHEMA [exe] AUTHORIZATION [dbo]')
END
Posted by: Guest on September-03-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language