Clever Geek Handbook

Is it possible to move triggers to their own file in an SSDT project?

I have a Visual Studio or SSDT database project of my companies.

I have folders for tables, views, stored procedures, etc. and I was wondering if you have a folder for triggers.

Triggers are currently stored in the same file as the table definition, and I would like to separate them if possible.

+3


source to share


2 answers


Yes, you can install triggers in separate files. There is no automatic way to do this, so you have to create these separate files manually.



+2


source


I'm not sure if you can do this automatically when importing the database, but you can definitely create a new separate file for the trigger and place it in any folder you like.



The location of the file - it doesn't matter, you can put it in any folder you like.

0


source






More articles:


All Articles