SQL Server sp_helpconstraint constraint_keys字段在PHP中最多被截断为256个字符

Question

I am writing a sQL parser to compare existing SQL database definitions to expected definitions via a DDL file.

I'm parsing constraints at the moment, but noticed that the constraint_keys column in the sp_help/sp_helpconstraint function(s) only seem to return 256 chars of the column in PHP/MSSQL.

I see a related question/answer here regarding 256 char varchar columns and how to get longer than this out of the PHP/MSSQL interface...

however, can I do this with the sp_constraint query? If so how?

Answer 1

Use the official SQL Server PHP driver, they support all SQL server types properly.