title: Alternative of sp_depends in Azure Data Warehouse
body: <p>I need to get the list of tables used in a stored procedure,However in Azure Datawarehouse sp_depends is not supported.</p>
  
  <p>The other alternative I thought of having is to get the stored proc code from INFORMATION_SCHEMA.ROUTINES and then run a script to get the [schema].[tablename] from the stored procedure definition but here the issue is in storing the whole stored proc into a variable. VARCHAR(MAX)has a limit of 8000 to store and if my proc exceeds this limit then I wont be able to get the complete table list. </p>