How do I fetch synonym names with the SQLTables function in ODBC API?
Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0, <br>SQLCHAR*)"'TABLE','VIEW','ALIAS','SYNONYM'", SQL_NTS);</p><p>I am getting back a table and views in a result set -- but no synonym.
Software/Hardware used:
sql server 2005
Software/Hardware used:
sql server 2005
ASKED:
November 10, 2009 9:40 PM
UPDATED:
November 10, 2009 10:00 PM
RELATED QUESTIONS
- Effective ways for retrieving millions of records from a table?
- Writing a stored procedure across two databases
- What is the difference between RAM and Cache Memory in SQL Server 2005?
- Meaning of a No Such File error message when copying files from OpenVMS to NAS drive?
- Troubleshooting Data Mining in SQL Server Analysis Services 2005
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
