Database Diagrams in SQL Mobile Database

[ozonic]

I am new to applications for mobile devices and I have a bit of a problem. How can I add database diagrams to an SQL Mobile Database, since database diagrams are not listed under the database in the Server Explorer when creating applications for mobile devices.

If however this is not possible for mobile devices, how can I then specifiy relationships between the tables?

 

[strider]

There are no such capabilities on SQL Mobile, instead you will need to use table constraints
eg MyCol int REFERENCES MyTable2(MyColumn1) ON DELETE CASCADE

have a look at http://msdn2.microsoft.com/en-gb/library/aa237902(SQL.80).aspx
there is a section on FOREIGN KEY...REFERENCES

 

[ozonic]

Thanks Strider, you've been a great help!