Please note that the content of this book primarily consists of articles available from Wikipedia or other free sources online. The Database Console Commands are a series of statements in Transact-SQL programming language to check the physical and logical consistency of a Microsoft SQL Server database. These commands are also used to fix existing issues. They are also used for administration and file management. DBCC was previously expanded as Database Consistency Checker. This statement is used to recreate the ...
Please note that the content of this book primarily consists of articles available from Wikipedia or other free sources online. The Database Console Commands are a series of statements in Transact-SQL programming language to check the physical and logical consistency of a Microsoft SQL Server database. These commands are also used to fix existing issues. They are also used for administration and file management. DBCC was previously expanded as Database Consistency Checker. This statement is used to recreate the indexes for a particular table. This statement rebuilds indexes in a single step. It also assigns fresh pages to reduce internal and external fragmentation.This statement is used to drop or delete a damaged database. However, this command is no longer available with Microsoft SQL Server 2005 and later versions of Microsoft SQL Server.
Overview