Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

comment on

( #3333=superdoc: print w/replies, xml ) Need Help??

Your question is a bit vague, but I will try to guess at what you mean.

  • You want to clear tables before loading them with data?
    Depending on your permissions to the DB, 'TRUNCATE TABLE' followed by 'INSERT' will be the fastest. 'DELETE FROM' works, but is slower as it gets logged. This will preserve the table design, while clearing its contents.
  • You want to remove a table and recreate it with new rules?
    I would examine 'ALTER TABLE', which will probably do what you need. If it doesn't, your only real option is 'DROP TABLE' followed by 'CREATE TABLE'
  • You want to create a table from data that's already in the database?
    I suggest researching 'SELECT ... INTO' syntax.
You probably are looking for a pure-SQL solution, in which case your question is a bit off-topic. However, if you are looking for ways to implement SQL Server access without having to learn SQL, DBIx::Abstract is a good place to start. There are several other modules that perform abstraction also available on the CPAN.

If it is just SQL you're after, drop me a private message and I will see if I can help.

Anima Legato
.oO all things connect through the motion of the mind


In reply to Re: SQL table recreation by legato
in thread SQL table recreation by Win

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others rifling through the Monastery: (4)
    As of 2020-01-25 17:58 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?
      Notices?