Skip to main content

    Data Warehouse

    Completed

    support DROP IF EXISTS

    Vote (3) Share
    Saveen Reddy's profile image

    Saveen Reddy on 16 Nov 2022 20:31:42

    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


    Administrator on 20 Jun 2023 13:48:02

    This is supported in Fabric.  We are not pusuing this for Dedicated or Serverless Pools at this time.

    Comments (1)
    Saveen Reddy's profile image Profile Picture

    Kevin Conan on 05 Jun 2023 21:51:31

    RE: support DROP IF EXISTS

    DROP IF EXISTS is supported in Fabric Data Warehouse.