Guest User

Untitled

a guest
Oct 23rd, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.13 KB | None | 0 0
  1. select distinct t.name
  2. from sys.partitions p
  3. inner join sys.tables t on p.object_id = t.object_id
  4. where p.partition_number <> 1
Add Comment
Please, Sign In to add comment