Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re: SQL table recreation

by legato (Monk)
on Jan 05, 2005 at 14:45 UTC ( #419630=note: print w/replies, xml ) Need Help??

in reply to SQL table recreation

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

Replies are listed 'Best First'.
Re^2: SQL table recreation
by Win (Novice) on Jan 05, 2005 at 15:01 UTC
    I want to be able to create and insert data for a table and do that within a stored procedure. I already have this table, but I want the code that would allow me to recreate this table within a stored procedure.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://419630]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (5)
As of 2020-10-28 06:41 GMT
Find Nodes?
    Voting Booth?
    My favourite web site is:

    Results (260 votes). Check out past polls.