Create table using SAP HANA Web-based Development Workbench:catalog error .

[Former Member]

When i tried to create a table using SAP HANA Web-based Development Workbench then it gives an error .

SQL statement to create a table

create table TEST (PersonID int,LastName varchar(255),FirstName varchar(255),Address varchar(255),City varchar(255))

Error :

Statement: 'create table SYS.TEST (PersonID int,LastName varchar(255),FirstName varchar(255),Address varchar(255),City varchar(255))'.Error executing Update: insufficient privilege: only internal SYS user can modify objects in SYS and _SYS_AUDIT schema: line 1 col 14 (at pos 13)

How to resolve this error ? I am having trial account , would like to create few tables .

[Former Member · Accepted solution]

Hi Sonu,

You may need to add the schema name before the table name like create table <YOUR_SCHEMA_NAME>.TEST (PersonID int,LastName varchar(255),FirstName varchar(255),Address varchar(255),City varchar(255))

Best regards,

Wenjun