User:TimothyChenAllen/Cerner
From Simple English Wikipedia, the free encyclopedia
[edit] How to recover the DUMMYT table in Cerner
The DUMMYT table is used in many Cerner processes. It is a table with two columns and a single row. If it is dropped or corrupted, you are truly messed up. Here is how to recover it if it ever goes away. Sign on to CCL with DBA privileges and issue this command:
DROP DATABASE DUMMY WITH DEPS_DELETED GO
CREATE DATABASE DUMMY
ORGANIZATION(SEQUENTIAL)
FORMAT(VARIABLE)
SIZE(32)
TYPE(c)
GO
