We have a table in the schema which was created by a certain user. How can I know what query the user executed to create that table (user is no longer with the company)? Basically trying to find out which underlying tables were used to create said user created table.
Apologies about the briefness, let me know what I can add to explain better.
