Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221

    Unanswered: Create/drop Table

    Suppose i have table name in a variable and i want to create/drop the table how should i go about it......????

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Generate the CREATE/DROP statement and execute it.

    If the variable is in an SQL procedure, you can use the EXECUTE IMMEDIATE statement for that. In other programming languages, you use regular dynamic SQL.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    Thanks that helped....

Posting Permissions

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