SAP Knowledge Base Article - Preview

2671648 - About Create Schema sql command -SAP IQ

Symptom


In SAP IQ, it is possible to create schema with sql command

CREATE SCHEMA AUTHORIZATION <userid> ... [ { <create-table-statement> | <create-view-statement> | <grant-statement> } ]

Example:

CREATE SCHEMA AUTHORIZATION User_A
CREATE TABLE test_A1 ( id1 INT PRIMARY KEY )
CREATE TABLE test_A2 ( id2 INT PRIMARY KEY )
GRANT select on test_A1 to User_B
GRANT select on test_A2 to User_B

 

Question:

What is the command or system table which allows to find Schema created using command above ?

 


Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0
  • SAP IQ 15.x

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4

Keywords

Sybase, IQ, CREATE SCHEMA, SCHEMA, AUTHORIZATION , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.