<div>
First you have to create new schema:<br />
<br />
CREATE SCHEMA [newschema] AUTHORIZATION [dbo]<br />
<br />
(The AUTHORISATION part you should change to appropriate user, dbo was used because it exists in almost all databases)<br />
<br />
Then you may create tables in this new schema:<br />
<br />
SELECT * INTO newschema.tblCandidatures FROM dbo.tblCandidatures<br />
<br />
and drop the original table from dbo:<br />
<br />
DROP TABLE dbo.tblCandidatures<br />
<br />

</div>


First you have to create new schema:

CREATE SCHEMA [newschema] AUTHORIZATION [dbo]

(The AUTHORISATION part you should change to appropriate user, dbo was used because it exists in almost all databases)

Then you may create tables in this new schema:

SELECT * INTO newschema.tblCandidatures FROM dbo.tblCandidatures

and drop the original table from dbo:

DROP TABLE dbo.tblCandidatures



<div>
geesh, yeah. shoulda had a better look. thanks
</div>


geesh, yeah. shoulda had a better look. thanks

<div>
<div class="content wysiwyg-content">
I am just beginning the use of schemas and need to know how to hange schema name on Tables in sql 2005 with Management Studio.<br />
<br />
how would I change this for example:<br />
dbo.tblCandidatures to newschema.tblCandidatures
</div>
</div>


I am just beginning the use of schemas and need to know how to hange schema name on Tables in sql 2005 with Management Studio.

how would I change this for example:
dbo.tblCandidatures to newschema.tblCandidatures

Change schema name on Tables

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.