Home Forums SQL Server 2008 SQL Server 2008 - General Can some tell me how to transfer schema of "User Defined Table Type" (UDTT) in SQL 2008? RE: Can some tell me how to transfer schema of "User Defined Table Type" (UDTT) in SQL 2008?

  • Use ALTER SCHEMA, with the type::schema.object

    http://msdn.microsoft.com/en-us/library/ms173423.aspx

    CREATE SCHEMA OldSchema

    ;

    GO

    CREATE SCHEMA NewSchema

    ;

    GO

    CREATE TYPE OldSchema.MyTable AS TABLE

    ( IDCode INT

    , Location VARCHAR(200)

    )

    ;

    CREATE PROCEDURE OldSchema.MyProc AS SELECT * FROM dbo.MyLogger

    ;

    ALTER SCHEMA NewSchema TRANSFER OldSchema.MyProc

    ;

    ALTER SCHEMA NewSchema TRANSFER type::OldSchema.MyTable

    ;

    GO