Thursday, February 25, 2016

Change Schema For table in Sql 2014 by query

USE OnlinePOSDB
GO
ALTER SCHEMA Setup
TRANSFER [.Color]
GO
SELECT name, [schema] = SCHEMA_NAME(schema_id)
FROM   sys.tables
WHERE  name = '[.Color]'
GO

No comments:

Post a Comment