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 ONE Support launchpad (Login required).

Search for additional results

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