Detach Schema

Table of Contents



DETACH SCHEMA removes a namespace, a schema with all of its documents, indexes, security policies and child schemas, from the database and moves its files to a folder. The folder can later be attached to this or another database with Attach Schema.
  • The folder must not already exist.
  • The statement waits for other transactions that are using the schema to finish.
  • A failure never leaves a partially detached schema: the schema is unregistered before its files are moved, and is restored if the move fails.

  • Requires an account that is a member of an administrator role, because the statement reads and writes folders on the server.
  • Can't be used inside an explicit transaction, because moving files can't be undone by the transaction log.
  • The folder can be a quoted string or a string variable. It must be an absolute path, and must not be inside the server's data or transaction folders.
  • A folder path can't end with a backslash ('D:\Exports\'), because the backslash would escape the closing quote.



round-pushpin Detaches WordList:Translation to a folder.
DETACH SCHEMA WordList:Translation TO 'D:\Exports\Translation'




SQL :: Rebuild Index
Rebuilds an index from the documents in its schema.
SQL :: Transaction
Transactions make a group of statements all-or-nothing.