index > SQL Server Everywhere Edition > foreign key in sql server ce

foreign key in sql server ce

I have created tables in sql server CE and i am trying to add foreign key to table using alter table command from .net framework IDE with server explorer , but it is giving error that

alter table command is not supported. so how to add constraint

to existing table in sql server ce




amol
Amol Jagtap
What version of SQL CE are you using? If you are using SQL Mobile 2005, then according to the documentation, it should be allowed. Have a look at:

ALTER TABLE (SQL Server Mobile)
С?r?s??ρhΞr Sc?δl?ξη
my version is sql server mobile edition 03.00.5206.00


amol
Amol Jagtap
Can you please post your SQL command?


João Paulo Figueira (Device Application Development MVP)
João Paulo Figueira
reply 4

You can use google to search for other answers

 

More Articles

• SqlServerCe.dll
• Using Everywhere/Mobile from a service
• SQl Server CE question..
• Why I can't connect sql server 2000 with wm5 or emulator ?
• Deploying with sql server express
• Using resultset.IsDBNUll and getting error
• How to add data in sql mobile database from sql server 2005 manag...
• Create New SQL Server Mobile Edition Database
• CREATE INDEX statement for SQL Mobile not documented?
• "SQL Everywhere" is a Sybase trademark
Bookmark and Share
Welcome to Bokebb   New Update  
 

New Articles

• Strange Problem: .sdf 128MB filesize limit
• SQL Mobile Installation Problem on Device
• Everywhere Edition and VS Express
• Execution plans - SQLCE 3
• Sync sql server 2005 mobile edition with
• Transactions in SQL CE and CF2.0
• HostName and ReinitializeSubscription
• SqlCe Memory issue
• Corrupt SQLCE 2.0 Database File
• SQL server mobile deployment problem
• Using Crystal Reports with SQL Server Ev
• Using Merge Replication, Parameterized F
• cannot generate ResultSet code
• SQL Mobile support for CE 4.2
• Mobile Application Enquiry

Hot Articles

• SQL Server 2005 mobile edition free?
• SQL Ev databases--Case Sensitive?
• Using SqlCeEngine to verify/Restore a da
• Strange Problem: .sdf 128MB filesize limit
• CE upgrade tool?
• Sync of binary columns in SQL 2005 EV an
• VS 2005 - VB.NET - Connect to mobile SQL
• SQL Mobile in pocketpc 2003 se desktop c
• Where is DataDirectory ?
• Newbie: "Sql mobile" or it is
• Top Instruccion
• LIKE % question
• Any Movement on the 4 gig limit???
• How solid is Sql Server Everywhere?
• Query:how to transfer data from a .net a

Recommend Articles

• Visual Studio 2005 The remote connection
• HostName and ReinitializeSubscription
• FlushFailure
• Upgrade scripts for SQL Server Mobile Da
• Dling support?
• Merge Replication with SQL Server 2000
• Compact Database Error Code: 0
• No Factory?
• SQL Mobile 2005 NVarChar Truncation Prob
• MDB to SDF
• A request to send data to the computer r
• SDK for SQL ev?
• SQL CE Err 80004005 "Unspecified Er
• VS 2005 Invalid database version SQL CE
• help