• you want to use the system view sys.synonyms, instead, which has everything you need:

    select * from sys.synonyms

    --rebuilding the command:

    select

    'CREATE SYNONYM '

    + quotename(SCHEMA_NAME(schema_id))

    +'.'

    + quotename(name) --ie MyView

    + ' FOR '

    + base_object_name --ie [SandBox].[dbo].[VW_FIXEDWIDTH]

    FROM sys.synonyms

    --Results:

    /*

    CREATE SYNONYM [dbo].[MyView] FOR [SandBox].[dbo].[VW_FIXEDWIDTH]

    */

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!