Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2008-09-29 : 12:24:19
|
| Guys,I have 500 views in the database, some of these views are referenced by the other views. I am trying to develop DDL script for all the views to be run in another database copy, but when I generate the DDL script for all the views from SQL Server Management Studio it does not order by Parent (referenced) and Child (referring) views. Is there any to generate the DDL scripts for the views in right order (referenced views first).Any suggestions and inputs might helpThanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-29 : 12:36:55
|
| Look at this one from Brett:http://weblogs.sqlteam.com/brettk/archive/2005/04/28/4830.aspx |
 |
|
|
|
|
|
DDL view generate script