Very quick post as I’m out the door to find tables that have no clustered indexes.
Import-Module SqlServer
Get-SqlDatabase -sqlserver 'ServerName' -dbname 'DBName' | %{
Get-SqlTable -Database $_ | where{$_.HasClusteredIndex -ne $true}| %{
$_.Name
}
}
Sql Server Powershell 
Leave a comment