Working with Scripts
You can use Visual Database Tools to work with Scripts. You can generate Change and Create scripts from within Table Designer; create scripts for SQL, stored procedures, triggers, tables, and views from Solution Explorer; or you can run scripts you create yourself.
When you create a script using Visual Studio, it will have the extension .sql, but if you have scripts with the following extensions, you can still use them:
.udtUser-defined data types
.drnDeclarative referential integrity
.fkyForeign key constraints