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



.bndColumn bindings



.udtUser-defined data types


.drnDeclarative referential integrity

.fkyForeign key constraints





Community Additions