on 05-30-2017 3:34 PM
Hi,
While creating a table in sql editor sap hana studio what is the syntax so that the table is created in desired schema using sql.
The default schema for your session is the schema that has the same name as your user.
For example, your user is called "SAPDEV" and it's default schema is also called "SAPDEV".
As users can own multiple schemas, you can switch with the "SET SCHEMA <schema_name>" command (https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.00/en-us/20fd550375191014b886a338afb4cd5f.html).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rohit,
You simply have to logon with the database user that OWNS the schema you want.
Example:
If your SCHEMA is SAPSR3, you have to logon with SAPSR3 user, then simply create the table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi lars,
When i m trying to retrive the tables present in the schema im able to retrieve even the system tables.
My requirement is I need to retrieve only the tables present in the schema but not the system tables(dafault tables).
Note: I want a solution such that we should not pass schema name in the SQL Query
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.