Post reply

How do I retrieve Foreign Key details?

  • October 22, 2009 at 1:30 pm

    #212870

    How can I retrieve the table a Foreign Key references in Server CE?

    In SQL Server 2005 I can get the Constraint Name from the INFORMATION_SCHEMA.TABLE_CONSTRAINTS then lookup up that constraint name in the SYS.FOREIGN_KEY_COLUMNS. But Server CE does not have SYS.FOREIGN_KEY_COLUMNS.

    I need to display the table name my FK is referencing.

  • October 23, 2009 at 10:05 am

    #1070141

    Try SDF Viewer

    You can quickly see the foreign key constraints for version 3.1 or 3.5 SQLCE databases.

  • November 26, 2009 at 9:53 am

    #1084651

    You just need to execute sp_help tablename , it will result different data sets, the last data set gives you the details of ForeignKey reference.

    Note : If sp_help is configured to your Alt+F1 , then in query window just type object name (say tablename) and dobleclick it (to select) then press Alt+F1.

    Regards,

    MC

    Thanks & Regards,
    MC

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply