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.
.oO all things connect through the motion of the mind
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:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- 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
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||