sqlschool.gr logo

articles

Articles of SQLschool.gr Team

Change Schema on an object in SQL Server database

Antonios Chatzipavlis
Monday 23 July 2012

Μια πρωινή ερώτηση που ένας συνάδελφος μου έθεσε ήταν η αφορμή για αυτό το tip of the day. Η ερώτηση του ήταν:

Πως μπορώ να αλλάξω το schema σε ένα object μέσα σε μια database;

Η απάντηση είναι απλή και φαίνεται στο παρακάτω παράδειγμα

USE master;
GO
IF ( db_id('dbDemo') > 0 )
    DROP DATABASE dbdemo;
GO
CREATE DATABASE dbDemo;
GO
IF (OBJECT_ID('T') > 0 )
    DROP TABLE dbo.T;
GO
USE dbDemo;
GO
CREATE TABLE dbo.T
(
         ID          INT IDENTITY(1,1) NOT NULL
    ,    ColA        INT NOT NULL
    ,    ColB        INT NOT NULL
    ,    RecordData  CHAR(1981) DEFAULT (REPLICATE('a',1981))
);
GO
CREATE SCHEMA new;
GO
ALTER SCHEMA new
TRANSFER dbo.T;
GO

Προσοχή

Όλα τα permissions τα οποία έχουν ορισθεί στο object που μεταφέρεται διαγράφονται.

Καλημέρα και καλή εβδομάδα

/*antonch*/

Antonios Chatzipavlis

Antonios Chatzipavlis

Antonios Chatzipavlis is a highly experienced Data Solutions Consultant and Trainer. He has been working in the IT industry since 1988, holding various roles such as senior developer, IT Manager, Data & AI Solutions Architect and Consultant.

Since 1995, Antonios has focused on modern technologies and software development tools, primarily by Microsoft. He has specialized in Data & AI since 2000, with expertise in Microsoft Data Platform (SQL Server, Azure SQL Databases, Azure Synapse Analytics, Microsoft Fabric, Power BI, AI) and Databricks.

Antonios is also a Microsoft Certified Trainer (MCT) for over 25 years, has been recognized as a Microsoft Most Valuable Professional (MVP) in Data Platform since 2010 and he is in the Data Expert 40 Powerlist 2024 by Boussias. He is the co-founder and visionary behind XLYTiCA, a company dedicated to Data & AI solutions.

Episode

Task Flows in Microsoft Fabric

image

More Episodes...

Tip

Get Certified: Become a Fabric Data Engineer

More Tips...

Become a member

If you want to receive updates from us become a member to our community.

Connect

Explore

Learn

sqlschool.gr © 2010-2025 All rights reserved

This site uses cookies for operational and analytics purposes only. By continuing to browse this site, you agree to their use.