Small. Fast. Reliable.
Choose any three.
DETACH

detach-stmt:

DETACH DATABASE schema-name

R-04230-65027:[This statement detaches an additional database connection previously attached using the ATTACH statement. ] R-46672-40841:[When not in shared cache mode, it is possible to have the same database file attached multiple times using different names, and detaching one connection to a file will leave the others intact. ]

R-05098-06501:[In shared cache mode, attempting to attach the same database file more than once results in an error. ]

This page last modified on 2022-01-08 05:02:57 UTC