akrashdi
03-22-2004, 11:43 AM
How can I make relations between two tables using query? Tables are already there with data.
Actually I uploaded my SQL Server DB to a free server for testing purpose. Tables were uploaded successfully but the relationship between the tables were erased, I mean Primary key and Foriegn key. The problem is that the hosting people have only a web based panel working to update database and I have to use Query Commands to manage my DB.
Tables are already there, I just need to make relations (Primary & Foreign Keys) between these tables.
I hope I could make it a little bit clear.
Regards,
A.K.
Actually I uploaded my SQL Server DB to a free server for testing purpose. Tables were uploaded successfully but the relationship between the tables were erased, I mean Primary key and Foriegn key. The problem is that the hosting people have only a web based panel working to update database and I have to use Query Commands to manage my DB.
Tables are already there, I just need to make relations (Primary & Foreign Keys) between these tables.
I hope I could make it a little bit clear.
Regards,
A.K.