Thank you

Here you go ,

Insert table2

(col1,col2......coln)

select (col1,col2...coln)

from table1

with this script you can insert all rows from table1 to table2

Thank you very much..................

Thank you for the reply...

There are series of scripts like this and i am using this scripts(existing) to create a deployment command file for the tables i have created.

well i...