Search and Replace

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

There are several different ways to find and replace text. On the Edit menu, Find and Replace offers four choices: Quick Find, Quick Replace, Find in Files, or Replace in Files. Each of these opens versions of the Find and Replace dialog box. You can also search without a dialog box by using incremental search keyboard shortcut keys. These techniques allow you to control the scope of find and replace, and choose the method of reviewing search matches and replacements.

You should consider the following when you search and replace text:

  • Options set in the Find and Replace dialog box affect all the searches. These options include Match case, Match whole word, Search up, Search hidden text, Wildcards, Regular Expressions, Look in All Open Documents, and Look in Current Project. All options are not available in all versions of the Find and Replace dialog box.

  • Undo is available only for documents left open after a replace operation.

  • Undo for a Replace All operation that spans more than one file is considered a single, bulk action across all the affected files. That is, you cannot undo the change in some files while retaining the change in other files.

Generally, you cannot search items with graphical views.

See Also

Search an Active Document Incrementally
Search Documents Interactively
Search Documents Using Results Lists
Search Text with Wildcards
Search Text with Regular Expressions