I have an Azure SQL database and am trying to drop a full text catalog. I get an error that says "Cannot drop full-text catalog because it contains a full-text index.
I've gone in and deleted every full-text index from the db, yet the error persists. Is there a T-SQL statement I can run to see the exact index that this catalog supposedly contains? Note that right-clicking on the full text catalog in SSMS has very limited options (not even Properties) when working in an Azure SQL database, hence the need for doing this in T-SQL.
