Skip to Content
avatar image
Former Member

How to add table created via System SQL Console to Repository

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers