HANA Schema tables replication to other schema

[Former Member]

All,

I am having a very unique requirement like....

Say i am having 2 Schema's like Schema1 & Schema2.

In Schema2 i am having 2 tables.

In Schema1 i am having 0 table

Now i am having a requirement like the 2 tables which are created under schema2 has to bedisplayed under schema1.

So what command do i need to use to get it done.

[Former Member · Accepted solution]

Hi Sekhar,

If you want to have those tables inside Schema1, then you can copy the tables in Schema1 with or without data from Schema2.

For copying the table with data, the command is:

create table Schema1.<table name> like Schema2.<table name> with data ;

If you want to copy without data then use "without" in place of "with" in the command.

Regards,

Amit

[Former Member]

Hi sekhar,

please go through the following statement

create table  schema.1 <tablename> as (select * from schema2.<tablename>);

[Former Member]

Please go through with the below link.

https://scn.sap.com/thread/3169291

Regards,

VaraPrasad

[Former Member]

Thanks all for giving the resolution