The integration of SQL Servers in Visual Studio is really great. I use VS to create my SQL tables and simple administration stuff – it´s not often that I start SQL Management Studio. But one thing is really annoying: You can´t rename SQL Tables in VS! But there is a little trick to do that.
If you create a relationship between to SQL tables, you get many benefits. The most important benefit (for me) is the integrity of your data. Besides the database-world there is another huge benefit: The relationships are used by many O/R mappers to create a structured object model. You could create such realtionships via different dialogs in the SQL Management Studio / Visual Studio or just do a "Drag´n´Drop" from one table to another one.
German
English
