title: Can I query a procedure's RequestText in Teradata?
body: <p>Teradata has a useful view called <code>dbc.tables</code> that you can use to query objects.  I've used this to query the <code>RequestText</code> in views with success, but procedures seem to be compiled a bit differently.</p>
  
  <p>When I look at the <code>RequestText</code> of a procedure (TableKind P), all I get is something like this:</p>
  
  <pre><code>ALTER PROCEDURE '468137'xn.'546321987654321345646556213165468654654654'xn COMPILE /* mydb.procedurename */;
  </code></pre>
  
  <p>Is this a reference to the actual RequestText that's stored elsewhere?  How do I get to it?</p>
  
  <p>I want to actually query it with SQL, not dump it to a text file.</p>
  
  <p>The reason why is because I need to run a LIKE statement against it to search for references to a specific table name.  It would be inconvient to have to dump it to a text file and then search the text file manually.</p>