SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Bryian Tan / List columns data type and size for every table in a database / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 19:06:23 GMT20RE: List columns data type and size for every table in a databasehttp://www.sqlservercentral.com/Forums/Topic785434-1645-1.aspxNeat 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.Mon, 12 Apr 2010 17:51:59 GMTiliebermList columns data type and size for every table in a databasehttp://www.sqlservercentral.com/Forums/Topic785434-1645-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/data+definition+language/68057/">List columns data type and size for every table in a database</A>[/B]Wed, 09 Sep 2009 18:07:20 GMTBryian Tan