How can I see all the scripts in a SQL server?

sqlor · December 15, 2020, 7:09pm

Hello

In a SQL server, how can I see the scripts that run on imported data which result in the available tables and views?

From what I understand, the DBA imports some tables 'manually' i.e. from the cloud. They then somehow transform that data through various layers and they produce several other tables based on the originally inserted tables.

I want to see the whole transformation journey. Is that possible?

Thanks!

mike01 · December 15, 2020, 7:13pm

I would ask the DBA.. It sounds like a typical ETL process with SSIS

jeffw8713 · December 15, 2020, 7:34pm

If you want to see all of the objects related to a specific 'string' value (e.g. a table name) - download and install SQL Search from Redgate.

Using that utility - you can then search all databases for a particular string value and find all tables, views, procedures, functions, etc... that have that string value.