Viewing table relationships in SQL Server Management Studio

Hi Yes it is possible to open any sql server from within management studio when you have the correct odbc driver to do so. Create an ODBC connection to the *.db3 file and call it something like SQLite then try this is a query window

-- needs to be a system odbc connection not user

EXEC sp_addlinkedserver 
   @server = 'SQLite', -- the name you give the server in studio 
   @srvproduct = '',
   @provider = 'MSDASQL', 
   @datasrc = 'SQLite' -- the name of the system odbc connection you created
GO

This is how you get the data, you can create views using this sql as well if you like

SELECT * FROM OPENQUERY(SQLite, 'SELECT * FROM tbl_Postcode')

With some googling, I came across: Color Schemes in SQL 2005 Management Studio.

From the site:

Enter VSColorsToSql

This is a simple utility I wrote last night that will port your current VS2005 Fonts And Colors Settings (just for the code editor, mind you) to Management Studio. It's nothing fancy, so all it does is copy some registry settings around.

I'd love to have something simpler. I wonder if this is the best way thus far.