If you go to the YQL console:
http://developer.yahoo.com/yql/console
There's a search box in the Data Tables module on the right column. Type in fantasysports and it'll show you all the fantasy sports ones that are available in YQL.
For the actual APIs, the best pointers I can give would be to check out the documentation:
http://developer.yahoo.com/fantasysports/guide
QUOTE(Ronnie @ 22 Oct 2011 9:42 AM)
Is there a comprehensive list of tables that are available for yahoo spots queries?
i.e. fantasysports.leagues.standings and other tables?