Skip to content

Instantly share code, notes, and snippets.

@jsranko
Last active August 4, 2020 12:50
Show Gist options
  • Save jsranko/a4df33acbb845bb76db617e33e06a642 to your computer and use it in GitHub Desktop.
Save jsranko/a4df33acbb845bb76db617e33e06a642 to your computer and use it in GitHub Desktop.
All sources of the system with SQL
select a.table_schema, a.table_name, b.table_partition, c.recorddata
from systables a
join syspartitionstat b
on a.table_name = b.table_name
and a.table_schema = b.table_schema
join table(siiia/SIPFM_ListData(a.table_schema, a.table_name, b.table_partition)) c
on 1 = 1
where a.file_type = 'S'
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment