Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-10-04 : 05:29:19
|
Hi All,Is there any script or command to find out tables in a database without index(s).Thanks in advanceSachin Samuel |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-04 : 05:37:24
|
Try thisselect table_Name from INFORMATION_SCHEMA.TABLES TWhere not Exists(select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where table_Name=T.table_Name)MadhivananFailing to plan is Planning to fail |
|
|
|
|
|