How to: Add SQL Scripts to a Database Project
You can use Server Explorer to add a new SQL script to a database project.
Note
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.
To add SQL scripts to a database project
In Solution Explorer right-click the project to which you want to add a SQL script, and then click Add New Item.
In the Add New Item dialog box, under Templates, click SQL Script.
Rename the script if you like.
Click Add.
The SQL Editor window opens where you can create your script.
From the File menu click Save script name.
The script is saved in the project folder.