I'll say this up front - a lot of small dog breeds don't work well when left alone for hours at a time. Any kind of terrier, or breed that has come from terrier stock, are serious trouble unless you can be very strict and regimented with their training early on. A lot of people don't know that terriers were bred to catch mice, rats, and other pests out in fields and hay stacks. They were designed to be more of an 'area defence' compared to cats, and they also hunted in absolutely vicious packs. The reason you see so many yappy and poorly trained terriers is that the owners haven't been able to, or are just too lazy and/or spoiling, to break them out of their basic genetic desires. Again, as a working dog of sorts they are not happy when they are cooped up in confined spaces without a master or companion. Not only will they wreck your shit it's really bad for the dog too as they get all stressed out and anxious.
I highly recommend crating just about any dog you'll have in an apartment. If you do it from when they're a puppy and make that their usual resting place then the crate becomes a place of comfort, not the 'bad dog' prison. Crating into adult dog life is also helpful as you can put your dog in the crate when you're at work or out of the house and they'll hopefully just relax or go to sleep as they've been raised to think of the crate as a restful place. Also, crating creates dominance and can be useful in pack dogs so they don't get all nervous in the master's absence and try and become the leader themselves.
The real bitch about many small dogs (pardon the pun) is that, because they have been bred over time to be companion dogs, they often suffer from separation anxiety making them ill-suited to new owners or homes where there will be no other occupants for more than 2 or 3 hours a day. Working dogs like collie breeds aren't much better. Without 'work' to do they get restless, become sullen, and can become aggressive, lash out destructively on furniture or their surrounding, or do funny things like herd small children into the corner or a room or the yard. Seriously, it can happen and as funny as it is to me it's probably not much fun for the kids. On the flip side, big dogs like Mastifs, Huskies, Irish Wolfhounds, and the like can easily be left alone as adolescents and adults for hours at a time with proper training. Then there are stubborn breeds like bulldogs, dauchands, or the great pyrenees that without very careful, dominant, and structured training just won't respond to commands or generally give a fuck what you think. My girlfriend's mother has an English Bulldog that they raised when she was living with her and, while a total sweetheart, just does NOT respond to commands. Talking it for a walk can be a trying experience as for the first 200 yards she will go sprint about 10 or 15 feet, stop, refuse to move until you forceably drag her by the collar, sprint another few feet, repeat. However, this female bulldog seems to respond really well to men, and in particular ones who treat her with some authority instead of making smoochy noises and cooing about her cute wrinkles like her 'master'. Not that my girlfriend's mother is a bad owner, the dog just wants to be commanded.
I suppose that's the biggest thing really with any type of dog. As the owner you are not only the master but the leader of the pack, the alpha who provides order and leadership in the dog's life. Some breeds need this way more than others, and some breeds will become neurotic and suffer serious anxiety if it's not there because the dog then tries to be the leader. They then see the owners and family as their responsibility, to provide food for and security - no wonder some dogs just go nuts to get out of the house. I feel like there are a lot of people out there who think that smacking your dog as a reprimand for bad behaviour is akin to torturing it. A firm hand is needed, often much more with bigger or physically dominant breeds, but only coming from love and authority. If you strike out with anger or malice your dog will begin to fear you instead of respecting you; fear leads to anger, anger leads to hate...well you see where this is going lol. Don't try and talk and reason with a dog either. Some breeds are exceptionally intelligent but they don't fucking understand human speech like we do. I worked pizza delivery for a while to pay the bills a few years ago and poorly trained dogs were not only annoying but downright dangerous. I began to hate taking deliveries to the pets-allowed apartments because my walk down the hallway or knocking of the door would invariably be met with frenzied yapping and then a few shouts of "shut the fuck up you stupid dog!" from the owners who likely molly-coddled of just outright didn't train their now unruly and likely nervous and unsettled dog.
If you've got the space here's a wicked breed some friends of mine who are married and have a house have raised from a puppy to now just over 2 years old:
http://en.wikipedia.org/wiki/White_German_Shepard It's an absolutely beautiful breed of dog, and while it was pretty rambunctious as a puppy (as most big dogs are) they have trained and socialized it very well. The husband had dogs as a kid but the wife never had. They were really committed to training it well and found some very good schooling in town. It also works for them since they both run at different times of the day - the breed loves to run, go on long walks, and have lots of vigorous exercise. I remember visiting their house every month or two as it was growing up and where as other guests would just try and ignore the big puppy when it got in their faces or tried to jump up I would just be commanding with it, grab it by the scuff of the neck, and make it sit or lie down - just as a way to assert dominance over it and try to calm it a bit. Now when I visit them it still comes up to visitors and sniffs about and is very friendly (but not doing anything bad like jumping or anything) but it comes over to me, sniffs me once or twice and usually just sits down or stands at attention in front of me - just like it does for its masters. I'm not out here to brag or anything, just an anecdote to show that dogs appreciate good-natured authority and dominance. They find themselves in a comfortable place as the happy member of a pack where they can enjoy their lives and be content.
Anyways, that was a pretty epic tl;dr but I hope it was useful. Good luck and I hope you find something that works for you.