Star User Guide > Star User Guide > B. SQL Statement Summary > SQL Statements Not Supported by Ingres Star
Was this helpful?
SQL Statements Not Supported by Ingres Star
Currently, you cannot use the following statements against a distributed database (although most can be executed within a direct connect or a direct execute immediate statement).
The unsupported SQL statements are:
create|alter|drop location
declare|alter table
create|alter|drop user
Events:
create dbevent
drop dbevent
get dbevent
raise dbevent
register dbevent
remove dbevent
raise error
Groups:
alter group
create group
drop group
comment on
message
create index
declare global temporary table
Integrities and permits:
create integrity
drop integrity
drop permit
revoke
grant
modify
Procedures:
create procedure
drop procedure
Roles:
alter role
create role
drop role
Rules:
create rule
drop rule
Schema:
create schema
drop synonym
Security alarms/audit:
create security alarm
drop security_alarm
enable security_audit
disable security_audit
Synonyms:
create synonym
drop synonym
Set statements not listed under  Set.
The indexes, integrities, and permits of each underlying local DBMS are enforced by the respective local DBMS.
Last modified date: 01/30/2023