Tuesday, 14 October 2014

Change the schema of a table in sql server

ALTER SCHEMA [SCHEMA-NAME] TRANSFER [TABLE-NAME]

Eg: Alter Schema Emp Transfer dbo.Employee

No comments:

Post a Comment