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:
.tabTable definition
.prcStored procedure
.viwView
.trgTrigger
.bndColumn bindings
.defDefaults
.rulRules
.udtUser-defined data types
.idnIdentity
.drnDeclarative referential integrity
.fkyForeign key constraints
.prvPermissions
.logLogins
.usrUsers
.grpGroups
In This Section
How to: Run SQL Scripts in Solution Explorer
How to: Generate Change Scripts
How to: Run a Script on a Database Other than the Current Default
Reference
Reference (Visual Database Tools)