support DROP IF EXISTS
SQL Server supports this already
currently I have to use this workaround
IF EXISTS ( SELECT * FROM sys.external_tables WHERE object_id = OBJECT_ID('yourSchema.yourTable') ) DROP EXTERNAL TABLE yourSchema.yourTable GO ...STATUS DETAILSCompleted