select * 
  from sys.tables
 where is_ms_shipped = 0

SELECT  name
FROM    sys.tables t
WHERE   t.is_ms_shipped = 0
        AND object_ID NOT IN ( SELECT   major_ID
                               FROM     sys.extended_properties
                               WHERE    minor_id = 0
                                        AND minor_id = 0
                                        AND class = 1
                                        AND name = N'microsoft_database_tools_support' )