With DDL, you can create and remove tables, schemas, domains, indexes and views.
SELECT, INSERT and UPDATE are DCL commands.
GRANT and REVOKE are DML commands.
COMMIT and ROLLBACK are DCL commands.
It checks the allocation of all the objects in the specified database.
It checks the structural integrity of all the objects in the specified database.
It checks for consistency in and between system tables in the specified database.
It checks the consistency of disk space allocation structures of a specified database.
DBCC CHECKALLOC - Checks the consistency of disk space allocation structures for a specified database.
DBCC CHECKTABLE- Checks the integrity of all the pages and structures that make up the table or indexed view.
DBCC CHECKCATALOG-Checks for catalog consistency within the specified database. The database must be online.