how to copy records and structure of table into new table

[Former Member]

Hi Everybody,

I want create new table from existing Customise table .

i.e, how to Copy Structure and records of existing customise table into new table?

Please , anybody tell me.

I am waiting for Your's Answers.

Thanks

Regards,

S.Muthu.

[Former Member]

Hi,

u mean to copying the table into anpother tht can be done by just copy it in to ztable name then it will copy the whole table with structures..

Regards,

Sana.

[Former Member]

HI Subbu

see u can copy only the structure of the tabl u want with ztable but if u want the records to be copied u have to write one program or manually u can enter the records but through copying u cant copy the records

wht u can copy is only the structure

plzz reward if u wan the program how to write i may help u plzz reward if help full....

my mail id is mutyalasunilkumar@gmail.com

[Former Member]

Hi Kumar,

Thanks for ur's Reply . I undestand only copy structure.

Thanks,

S.Muthu,

[Sathish]

Do you want to create dynamic tables and insert data into them??

[Former Member]

Sathish,

I want Create new customise table from Existing customized table structure and records.

Thanks,

S.Muthu

[Former Member]

Hi Sathish,

I want create new table with structure and records from Existing customised table.

Thanks,

Regards,

S.Muthu.

[Former Member]

Hi try this code to insert records from the existing table

data:

fs_temp type table_name(the table which holds records)

it_tab like standard table of fs_temp.

select * from table_name(the table which holds records)

into table it_tab.

loop at it_tab into fs_temp

insert into table_created(newly created table in the databse) from fs_temp.

endloop.

write: / 'records inserted succesfully'.

plzz reward or if u have any further quiries contact me

my mail id is mutyalasunilkumar@gmail.com