Database Schema and code question

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Database Schema and code question

Author

Topic

timsmith
Starting Member

11 Posts

Posted - 2008-08-05 : 09:11:33

Hi,

A couple of questions:

1. I wanted the schema for my database (MS SQL Server 2005) but I couldn't find a convenient way to do it. I googled and was a bit surprised to find that this functionality is not part of the MS Management studio, and that I would need to buy additional s/w for this. Is this correct?

2. I wanted to return non-matching rows between two tables. For example, if table X and Y both have FName and LName fields, then I want to return only those rows in X that do not have a match in Y. (I tried using the 'where not exists', but not successfully). Any hints/tips on how could I do this?

thanks!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-05 : 09:25:28

1)What you mean by "I wanted the schema for my database (MS SQL Server 2005) but I couldn't find a convenient way to do it."

2) Use left outer join.