>>I don't see in SSMS how to view relationships. Is it possible to define/view relationships like in VFP?
>
>I believe you can use Database Diagram. Or what exactly you're talking about? Referential Integrity relations?

Yes - Make a database diagram for your database, add your tables to it, and you can pretty much drag and drop your relations (FKs and such) as well as design the tables.