duplicating tables 2

[jesse1]

I am a Coldfusion programer that uses SQL 2008 as a backend but am not proficient sql. I would like to write a script that I can use to duplicate tables. For example, I have table1Dem, table2Dem and table3Dem.

I would like to duplicate table1Dem and table2Dem w/o carrying the data over. Table3dem I would like to duplicate the table and the data.

I would also like to pass a parameter for the naming of the new tables. Ie. I would pass "Lyn" and the new tables would be named table1Lyn, table2Lyn and table3Lyn.

I would appreciate any guidance in this area.

Thanks

 

[markros]

Please review this very interesting link

 

[snitin78]

Thanks, Markros! I wonder why the link does not work when I click directly on it...

 

[jesse1]

you have to copy and paste. Clicking ignores the hyphen at the end

 

[gmmastros]

Oh wow. Who would have thought?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

It seems to be a problem using link ending with - on other forums too. Perhaps there need to be something done to never end the link with -