PDW to find out which table are external table

Normal source of getting all the table list in the database.

1. INFORMATION_SCHEMA.TABLES
2. sys.tables
3. sys.objects
4. sys.all_objects
5. OBJECTPROPERTY ()
6. OBJECTPROPERTYEX ()

However, none of above can tell you which table is external table. In order to find out which table are external table, you will have to look into sys.external_tables.

Query

SELECT * FROM sys.external_tables