Even Before Setting the Table

Considering making the big move from two larger dining room tables of 4 and 6 to smaller square tables that will seat 2-3. Has anyone done this? I know it won't be cheap, but I do feel that it will be more attractive to the Gen-X and Gen-Y guests and beyond.
Should I go with pedestal type tables (one large, middle support), or ones with 4 legs?

I like pedestal style.

We have 4 square tables that can be moved together for groups. Yes, the guests we get like this. The table set for 4 is always the last taken. Even if I say, 'Sit wherever you like,' guests avoid that table.
Kind of table depends on type of guests. Most young guests stand up without heaving themselves out of the chairs by leaning their full weight on the table. Our tables are pedestal type. They tip. If I see a guest heaving out of their chair I'll go hang onto the other end of the table.
Don't really like the 4-legged tables as someone will always be crashing into the legs and sloshing the drinks.
My tables are about 30-31" square and can seat 4 comfortably but much better for 2-3.

I just want food on it

We got tables from Overstock.com that seat two with chairs for a great price. Our guests love private seating even though they are close to each other you don't have to talk if you don't feel like it. Some tell us they book us because of the table for two set up.
Riki

We have one round table that I set for 2 or 3 but it can be opened to accommodate 8 if necessary. We also have 2 square tables that are perfect for 2 at each.

I have thought of doing this myself. My preference is the pedestal type. Can you use the chairs from your existing larger table and buy only the new tables, to help with the expense?

We just did that in Oct. Our guests love it! And we've been left tips too!
We bought some of our tables from online auctions, and all our chairs, and my son made the rest of them.
My tables were $7 ea on auction. and they are pedestals.

Oh, WOW! I didn't expect such the positive response! Thanks very much. DH is the one who is the sticking point. He's not sure about it.
Yes, I believe we can use the chairs that we currently have. I've had the seats reupholstered and just a couple of years ago had a furniture repair company reinforce all the legs and such. They're good quality, but they are probably 40 years old.
And tables for $7 each!!? That's fantastic! I was going to check with some of the restaurant liquidator places around us. I think there's one in Baltimore.