Install the ASSP assembly on the AS instance (http://asstoredprocedures.codeplex.com/)
Then run the following:
CALL ASSP.DiscoverXmlMetadataFull("\Databases\Database")
That's the only way I know of to look at it programatically unless you start querying the file system from SQL.