What is the DBCC command and why it is used
What is the DBCC command and why it is used
The Database-Consistency-Checker(DBCC) will help us to check the consistency of the database, this is also known as database console commands.
This command falls under the Miscellaneous category.
Syntax
DBCC HELP ('?');
Into this category includes commands for the tasks related to database, index, and filegroup, as shown below.
Into this category includes commands for the tasks related to trace flag or DDL memory management, as shown below.
Into this category includes commands for tasks to collect or display different types of information, like below.
Inti this category includes commands for the tasks to perform some kind of validation actions on the database, index, tables, etc., which I would say are more useful in certain ways, like below.
Please log in or register to add a comment.