Restricted commands in SQL mode

Data Sources

Chartio prohibits the use of the following commands in SQL Mode to prevent malicious use of your data.  However, we still recommend only connecting with a user that is granted read-only access to your database.

Chartio is set up with a read-only access user. Teammates with Edit or Admin access to your database can read the data, but cannot do anything to modify the database. As an extra level of precaution Chartio scans and rejects any malicious keywords such as DELETE and INSERT before executing queries.

  • add
  • alter
  • analyze
  • attach
  • begin
  • break
  • catch
  • change
  • checkpoint
  • close
  • commit
  • continue
  • conversation
  • copy
  • create
  • cursor
  • dbcc
  • deallocate
  • declare
  • delete
  • deny
  • disable
  • drop
  • enable
  • end
  • execute
  • fetch
  • grant
  • get_transmission_stat
  • go
  • goto
  • insert
  • install
  • kill
  • load
  • load_extension
  • merge
  • notify
  • open
  • pragma
  • print
  • purge
  • raiserror
  • rename
  • reassign
  • receive
  • reindex
  • release
  • replace
  • reset
  • return
  • revert
  • revoke
  • rollback
  • save
  • savepoint
  • send
  • setuser
  • show
  • shutdown
  • start
  • stop
  • shutdown
  • throw
  • timer
  • truncate
  • try
  • update
  • updatetext
  • uninstall
  • vacuum
  • waitfor
  • writetext
  • while

Related Data Sources Help Articles

See more