Neat tool, thank you.
It seems to work for the tables under the dbo schema, but not other schemas in the database. *shoot*
In fact, I'm just looking for an easy way to loop through all the columns of a table, getting the name and type, and the primary key. Any help appreciated. Thanks! (In fact, I'm looking to do this for the inserted table in a trigger.)
This could be done easily from Java with MySQL using the MYSQL_FIELD structure and a few function calls (mysql_num_fields, mysql_fetch_field, etc.) But I'm looking for a quick way to do it just with MS T-SQL.