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 |
|
learntsql
524 Posts |
 Posted - 2009-11-10 : 23:37:14
|
| Hi..How to drop All/Specified database objects from a specified database. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
learntsql
524 Posts |
Posted - 2009-11-10 : 23:46:55
|
| After restoring original database into another database,i want to clean the data which may contain foreign keys.Instead trying to drop all objects and then run the script for required objects.Am i going in right way? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-11-11 : 00:41:15
|
quote:
Originally posted by learntsql
After restoring original database into another database,i want to clean the data which may contain foreign keys.Instead trying to drop all objects and then run the script for required objects.Am i going in right way?
In this case you can make use of Generate SQL Script feature by seleting required objects and run it in the target databaseMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Drop all/specific objects