Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.