locked
How to retrieve Whole synctable from local .sdf file using SELECT statement?. RRS feed

  • Question

  • Hi all

    I want to retrive whole synctable ( with data & columns ) using select command. I have used Information_Schema.Tables for this but it gives me only table property e.g.(table name,table type).

    "SELECT * FROM Information_Schema.Tables WHERE (TABLE_NAME ='Call')"

    I want table with data and columns structure.

    Is it any way to retrive whole table from sdf ??

    Regards,
    Meet.
    • Moved by Max Wang_1983 Friday, April 22, 2011 10:08 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Monday, September 3, 2007 2:15 PM

All replies

  • should that simply be "select * from call" ?

     

    thanks

    yunwen

    Saturday, September 8, 2007 5:51 PM
    Moderator

  • hi
    this will only retruns records, but i want record with table structure. Means Table + Records,

    Thanks & Regards,
    Meet Vijay Shah
    Wednesday, September 12, 2007 1:09 PM