DBCC Check table -iclr
🧩 Syntax:
USE Testdb
GO
ALTER DATABASE Testdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
DBCC CHECKTABLE ('Table1,REPAIR_REBUILD) WITH NO_INFOMSGS, ALL_ERRORMSGS;
GO
ALTER DATABASE Testdb SET MULTI_USER;USE Testdb
GO
ALTER DATABASE Testdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
DBCC CHECKTABLE ('Table1,REPAIR_REBUILD) WITH NO_INFOMSGS, ALL_ERRORMSGS;
GO
ALTER DATABASE Testdb SET MULTI_USER;