I've been tasked with trying to find the datasources in one of our system schemas. Is there an SQL statement that can do this? I've tried googling and checking the Exasol User Manual but can't find anything.
Searching for the datasource of tables in a schema
248 Views Asked by user7431342 At
1
There are 1 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in EXASOLUTION
- Working and feasibility of exasol "export" command
- Is there a way to restart an Exasol database instance automatically
- Get SRID of geometry column in exasol (ST_SRID equivalent)
- how to enableJsonFunctions=1 in exasol database?
- How to calculate value based on average of previous month and average of same month last year in SQL
- Informatica, [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified error when connecting to Exasol database
- How can I filter for CURRENT_DATE / SYSDATE - 2 years?
- How to select only ids that contain a column value of 0 in a date range?
- How to filter date range from "date" - 2 weeks and "date" + 2 weeks
- GROUP BY with CASE WHEN?
- Upload data to Exasol from python Dataframe
- pandas to_sql with Exasol
- How to specify data type in PyExasol export_to_pandas
- Exasol Update Table using subselect
- Trigger in Exasol DB
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
If you have the auditing enable in your EXASOL database you can use the table
EXA_DBA_AUDIT_SQLto find which SQL queries modified your table. The queries are in theSQL_TEXTcolumn.You can find more information about this table in the Appendix A of the EXASOL manual.