lyfz_repos/经典版源码/document/数据库维护脚本/检测数据库所有表.sql

/*检测指定数据库db*/
dbcc checkdb('db')

/*以下是检测数据库表*/
dbcc checktable('dbo.annualfee')
dbcc checktable('dbo.area')
dbcc checktable('dbo.bakstate')
dbcc checktable('dbo.baseexpendtype')
dbcc checktable('dbo.bumen')
dbcc checktable('dbo.burncdreg')
dbcc checktable('dbo.businessintention')
dbcc checktable('dbo.businesstype')
dbcc checktable('dbo.childmsg')
dbcc checktable('dbo.client')
dbcc checktable('dbo.client2')
dbcc checktable('dbo.client2phonerecord')
dbcc checktable('dbo.client2phonerecordout')
dbcc checktable('dbo.client3')
dbcc checktable('dbo.client3phonerecord')
dbcc checktable('dbo.client3phonerecordout')
dbcc checktable('dbo.clientcontract')
dbcc checktable('dbo.clientfrom')
dbcc checktable('dbo.clientqequirement')
dbcc checktable('dbo.clientreason')
dbcc checktable('dbo.clienttype')
dbcc checktable('dbo.digitalwork')
dbcc checktable('dbo.dindan')
dbcc checktable('dbo.dindanbukuan')
dbcc checktable('dbo.dindanbukuan2')
dbcc checktable('dbo.dindanjd')
dbcc checktable('dbo.dindansp')
dbcc checktable('dbo.dindansp2')
dbcc checktable('dbo.dindansp3')
dbcc checktable('dbo.dressarea')
dbcc checktable('dbo.dresshire')
dbcc checktable('dbo.dresshiredata')
dbcc checktable('dbo.dressinfo')
dbcc checktable('dbo.dresstype')
dbcc checktable('dbo.employeephonerecord')
dbcc checktable('dbo.employeephonerecordout')
dbcc checktable('dbo.expendtype')
dbcc checktable('dbo.filemanage')
dbcc checktable('dbo.filemanage2')
dbcc checktable('dbo.files')
dbcc checktable('dbo.fixedassets')
dbcc checktable('dbo.framesize')
dbcc checktable('dbo.gongyingshang')
dbcc checktable('dbo.growthtx')
dbcc checktable('dbo.gudingfeiyong')
dbcc checktable('dbo.gudingfeiyongxiangmu')
dbcc checktable('dbo.historydb')
dbcc checktable('dbo.hospital')
dbcc checktable('dbo.hospitalclient')
dbcc checktable('dbo.hospitalclientcontactreg')
dbcc checktable('dbo.insidemsg')
dbcc checktable('dbo.jd')
dbcc checktable('dbo.jdd')
dbcc checktable('dbo.log')
dbcc checktable('dbo.loginsign')
dbcc checktable('dbo.loninbanset')
dbcc checktable('dbo.lonindata')
dbcc checktable('dbo.membercard2')
dbcc checktable('dbo.membercard2blue')
dbcc checktable('dbo.membercard3')
dbcc checktable('dbo.membercard3childusereg')
dbcc checktable('dbo.membercard3usereg')
dbcc checktable('dbo.membermanage')
dbcc checktable('dbo.membermanageblue')
dbcc checktable('dbo.memberreg')
dbcc checktable('dbo.memberreg2')
dbcc checktable('dbo.memberreg2blue')
dbcc checktable('dbo.memberreg3')
dbcc checktable('dbo.memberreg4')
dbcc checktable('dbo.memberregblue')
dbcc checktable('dbo.misscallrecord')
dbcc checktable('dbo.msgcode')
dbcc checktable('dbo.msgtemp')
dbcc checktable('dbo.msgtemp2')
dbcc checktable('dbo.mywork')
dbcc checktable('dbo.Part')
dbcc checktable('dbo.path')
dbcc checktable('dbo.phonerecord')
dbcc checktable('dbo.phonerecordout')
dbcc checktable('dbo.photoprint')
dbcc checktable('dbo.renyuan')
dbcc checktable('dbo.rewards')
dbcc checktable('dbo.salary')
dbcc checktable('dbo.sale2type')
dbcc checktable('dbo.sendreg')
dbcc checktable('dbo.sendreg2')
dbcc checktable('dbo.sendregcard')
dbcc checktable('dbo.sendregdelay')
dbcc checktable('dbo.sendregreceive')
dbcc checktable('dbo.shangpin')
dbcc checktable('dbo.shangpinlb')
dbcc checktable('dbo.singleincome')
dbcc checktable('dbo.singleincomemoney')
dbcc checktable('dbo.storeinfo')
dbcc checktable('dbo.storeinfo2')
dbcc checktable('dbo.taoxi')
dbcc checktable('dbo.taoxifg')
dbcc checktable('dbo.taoxishangpin1')
dbcc checktable('dbo.taoxishangpin2')
dbcc checktable('dbo.todaytake')
dbcc checktable('dbo.txlb')
dbcc checktable('dbo.txlb2')
dbcc checktable('dbo.unknownphonerecord')
dbcc checktable('dbo.unknownphonerecordout')
dbcc checktable('dbo.update')
dbcc checktable('dbo.user')
dbcc checktable('dbo.version')
dbcc checktable('dbo.workrate')
dbcc checktable('dbo.worktype')
dbcc checktable('dbo.xtcs')
/*
dbcc checktable('')
*/