Skip to Content
0

How to add table created via System SQL Console to Repository

Dec 27, 2016 at 09:21 PM

23

avatar image

How can a table created via the System SQL Console to Repository.

Hana DB version history 1.00.122.05.148177062

Example:

1. Launch Hana Development Studio and login

2. Select 'Systems' tab and open SQL Console

3. Create new tables

CREATE VIRTUAL TABLE "CH105"."CH105_TEST_VT" AT "EDW_LANDING"."<NULL>"."<NULL>"."""EDW_LDG_OWNER"".""OMS_MAJOR_EVENT""";

CREATE COLUMN TABLE "CH105"."ergon.Data::CH105_TEST.hdbtable" LIKE "CH105"."CH105_TEST_VT" WITH NO DATA;

4. Select 'Repositories" tab

Question: How to add/display table

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers