none
How to determine datetime when U-SQL Database object was compiled

    Question

  • I have a few U-SQL databases that I've created in ADLA, and in each database I have compiled objects (stored procedures, table functions, views, etc.).  I want to see WHEN each item was last compiled similar to how I might query sys.objects in SQL Server.  I've looked for a way to see this on the Portal, as well as Visual Studio Data Lake Analytics Explorer, but I cannot determine that.

    Also, if I could query a "system" catalog to see this I could then compare two different databases (like QA vs Production, etc.).

    Thanks!


    Bill Blakey

    Wednesday, January 9, 2019 8:56 PM

Answers

  • Hi Bill,

    Please have a look at this doc on U-SQL :

    https://docs.microsoft.com/en-us/u-sql/objects-and-extensions/catalog-views/objects

    Let us know if this helps, else we can gladly continue the dialogue.


    MSDN

    Thursday, January 10, 2019 8:53 AM
    Moderator