Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    NM, USA

    Unanswered: Deleting lots of stuff from different places

    1. I'm still pretty new to writing serious SQL.
    2. I have a bunch of similarly named tables on a lot of different schemas on a lot of different servers.
    3. 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.

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts