Post reply

Generate SQL Scripts - Schema and Trigger

  • June 3, 2016 at 1:04 am

    #308161

    Hi ALL,

    Generating scripts for all the tables (Schema only) and triggers with single file per object mode.

    Here am getting the Table schema and trigger script in same sql file.

    I want the script file and trigger file should be separate .sql files.

    Please help.

  • June 3, 2016 at 5:59 am

    #1883044

    You can try going into the Tools, Options menu. Once there, scroll down to SQL Server Object Explorer. Select the Scripting option. Then scroll down until you see "Generate script for dependent objects". That's probably set to False. Change it to True. That ought to help.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply