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 2005 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: Generate Create Scripts

How to: Open Scripts

How to: Remove Scripts

How to: Rename Scripts

How to: Run a Script on a Database Other than the Current Default

Reference

Reference (Visual Database Tools)

Designing Tables

Designing Queries and Views