Pages

Friday, 24 October 2014

How to change SCHEMA name in SQL SERVER

  1. Description:
 A Database schema is a described structure in a language supported by DBMS.

Example:
USE databasename;
GO
ALTER SCHEMA new_schema TRANSFER old_schema.TableName;
GO

No comments:

Post a Comment