Export (0) Print
Expand All

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

Reference

Related Sections

Community Additions

ADD
Show:
© 2014 Microsoft