SQL statement to add a table as Virtual table in SAP HANA Smart Data Access

SAP HANASAPSAP Basis

You can use following SQL statement for this −

CREATE VIRTUAL TABLE <table_name> <remote_location_clause>

Example

CREATE VIRTUAL TABLE ABC.test_VT AT “ORCL_11G_WIN”.”NULL”.”OUTLN”.”Dept”;

In this SQL statement, ABC.test_VT is Virtual table name

“ORCL_11G_WIN”.”NULL”.”OUTLN”.”Dept”;- Remote location for creating Virtual table

raja
Published on 21-Feb-2018 22:39:08
Advertisements