DBCC USEROPTIONS

Return the SET options currently active (set for the current connection.)

Syntax
      DBCC USEROPTIONS [WITH NO_INFOMSGS]

Options:

   NO_INFOMSGS - Suppress all information messages.

Example

DBCC USEROPTIONS

“Eventually, all things merge into one, and a river runs through it. The river was cut by the world's great flood and runs over rocks from the basement of time” - Norman Maclean, A River Runs Through It

Related commands:

SET
SET TRANSACTION ISOLATION LEVEL

Equivalent Oracle command:

DBA_TABLES - Rows in table
DBA_TAB_COL_STATISTICS - Other column stats