Define relationships on remote MS SQL server 2000?

microsoft.public.sqlserver.tools

19 Apr 2006 8:05 AM

Noozer

Using Microsofts SQL Server Management Studio Express, is it possible to
define relationships between tables?

My database is hosted by my domain hosting company. I can connect to their
server and modify my tables without an issue, but I can't see how to relate
the tables.

Unfortunately, MS SSMSE can't find the local or online helpfiles.

Thanks!

19 Apr 2006 12:08 PM

John Bell

Hi

Have you checked out "Creating and Modifying FOREIGN KEY Constraints"
http://msdn2.microsoft.com/en-us/library/ms177463(SQL.90).aspx

John

Show quote

"Noozer" <dont.spam@me.here> wrote in message
news:%23dKACg4YGHA.4248@TK2MSFTNGP05.phx.gbl...
> Using Microsofts SQL Server Management Studio Express, is it possible to
> define relationships between tables?
>
> My database is hosted by my domain hosting company. I can connect to their
> server and modify my tables without an issue, but I can't see how to
> relate the tables.
>
> Unfortunately, MS SSMSE can't find the local or online helpfiles.
>
> Thanks!
>
>