Access SQL server database through PHP code

We are in the proccess of  migrating a database from MySQL to SQL SERVER 2008 R2. The database is being accessed by PHP code(through ODCB). When I ran Sql profiler, I noticed that besides all sql statment that are submitted to database some extra sql statments(below) are also being submitted.

SELECT
 column_name
FROM
 INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
 OBJECTPROPERTY(OBJECT_ID(constraint_name), ''IsPrimaryKey'') = 1 AND
 table_name = ''Table1''

Does anybody know why these extra select statments are being submitted and how can I stop that?

Can this be related to the ODBC driver that we are

August 19th, 2015 9:17pm

Is TABLE1 a valid table in your database? that query is finding the primary key column of table1 if there exists.
Free Windows Admin Tool Kit Click here and download it now
August 19th, 2015 10:36pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics