Sometimes if need to remove columns or fields from Table and try to compile and publish the AL extension again we face below error.

Error

Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.

Why it happens?

The object metadata in Sql sever could be different from that of your object.

sometime SQL does not recognize the columns or sync same time

What is the solution?

Try to put below parameter in launch.json in your AL extension file.

 

Hope it help and let me know for more details if we can add it here.