Is possible to specify reationships between tables on SQL Server Compact Edition database in Management Studio Express ?
I can connect to database file , add tables, add data , but I dont't found the right methot to specify reationships as with SQL Server Express.
Any ideas?
Have you found an answer?
Gus
|||You have to specify the relationships in the query analyzer, like this:
ALTER TABLE MyOrders ADD FK_CustOrder FOREIGN KEY (CustID) REFERENCES MyCustomers(CustID)|||Thanks Erik for the information. I know it can be done in code, I was hoping to find the complete table designer in the ce edition. I understand that it's not there. Apparently 'lightweight' refers not just to the product's functional capabilities, but also its development tools.|||Designing relationships visually will be available in the next version of SQL CE, version 3.5, included in Visual Studio "Orcas".sql