From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Verify integrity with console commands

Verify integrity with console commands - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Verify integrity with console commands

“

- [Instructor] SQL Server supports a wide variety of T-SQL statements that are collectively called database console commands, or DBCC statements. These statements are broken down into categories for informational statements that return valuable information about the state of the database, validation statements, which report back on the validity of databases, tables, indexes, and other objects, maintenance statements perform routine maintenance on databases or indexes, and miscellaneous statements which can perform a variety of other server and database related tasks. For a full listing of all of the available DBCC commands, visit this page at the Microsoft Developer Network Documentation. Clicking on the Informational Statements link on the far right-hand sidebar, we'll scroll down into a series of tables that display each category and the commands within. It also provides easy links to each of these statements in order to find out more information about them. So let's take a look at…

Contents