See why you might be getting unexpected syntax errors when using builtins within table-valued function calls.

See a quick metadata script that finds all tables, across all user databases, without a primary key.