Se poate!

Din T-SQL:

USE tempdb;

GO

CREATE SCHEMA S1;

GO

CREATE SCHEMA S2;

GO

CREATE TABLE S1.T(i INT);

GO

-- Move T from S1 to S2

ALTER SCHEMA S2 TRANSFER S1.T;

GO

SELECT * FROM S2.T;

GO

 

-- Clean-up

DROP TABLE S2.T;

DROP SCHEMA S1;

DROP SCHEMA S2;

Visual - right click in Object Explorer pe tabel, Design:

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro