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.
SELECTcolumn_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