10-22-12, 12:44 #1Registered User
- Join Date
- Sep 2008
- NM, USA
Unanswered: Deleting lots of stuff from different places
- I'm still pretty new to writing serious SQL.
- I have a bunch of similarly named tables on a lot of different schemas on a lot of different servers.
- I need to delete them all.
Soooo. I'm guessing I need to write some kind of stored procedure, but the concept of how best to do this is still rather nebulous to me. Can anyone out there forcibly thrust me in the right direction? Just...a general idea... some skeletal pseudo code...
Will greatly appreciate the help.
"Unix is user friendly... It's just very picky about its friends."
The best things in life...are well-documented.
10-22-12, 13:02 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
>I need to delete them all.
DELETE removes rows. It this what you really want to do?
post single SQL that does what you desire for a single table.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.