Anti-Semi-Join against sys.external_tables on matching object_id to exclude External Tables
Also fix for ignoring TVFs - the [type] column is a 1 or 2 letter code, 'TF' for Table Valued Functions, whereas the [type_desc] is a brief description, 'SQL_TABLE_VALUED_FUNCTION' for Table Valued Functions.
Anti-Semi-Join against sys.external_tables on matching object_id to exclude External Tables Also fix for ignoring TVFs - the [type] column is a 1 or 2 letter code, 'TF' for Table Valued Functions, whereas the [type_desc] is a brief description, 'SQL_TABLE_VALUED_FUNCTION' for Table Valued Functions.