Thursday, March 8, 2012

Creating relationships with MSDE

Is it possible to create relationships between tables using foregin keys with MSDE. I have looked for any information and can't seem to find anything.With MSDE you can use Visual Studio and MS Access. With Access you have to create new Data Project. Also you can use SQL Server Enterprise Manager to create relationships. But, you can be always more elite and use oSQL and create relations using SQL.

If you prefer writing SQL for relations then you should read T-SQL documentation. Check out chapters for CREATE TABLE and ALTER TABLE statements.|||Yes. You can create realationships as mentioned. Is there specific information you would like to know.|||Thanks Guys.

Helps to know that I wasn't going to crazy trying to figure it out.

No comments:

Post a Comment