Full-Text Search

Mirrors the in-app Help. The live copy in your console and `dlake guide help` are always current.

The Full-Text Search page (next to Indexes) manages SQL Server full-text indexes for word/phrase search over character and XML columns. First create the tenant’s catalog (one click), then pick a table — it needs a single-column unique key (a normal single-column primary key works) — choose the text columns to index, and create. A new index populates in the background; the page shows a live status chip (populating → idle) and lets you drop indexes with confirmation. If the database engine doesn’t have the Full-Text component installed, the page says so instead of offering setup. Full-text indexes also upgrade Documents search from pattern matching to word-aware ranking where available.