select * from sys.objects where type = 'U' and name like ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select *
from sys.objects
where type = 'U'
and name like 'PostHistory%' and not name = 'PostHistoryTypes'

select count(*) from posthistory
select count(*) from posthistory_1
select count(*) from posthistory_2
select count(*) from posthistory_3
select count(*) from posthistory_4

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results