SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Gaby Abed / Finding all data types in user tables / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 04:21:33 GMT20RE: Finding all data types in user tableshttp://www.sqlservercentral.com/Forums/Topic581097-1373-1.aspx[quote][b]casc (12/5/2008)[/b][hr]Hi Gaby.If this script should run on MS SQL Server, you have to fix it first!!!!BR cas[/quote]Umm...this script ran fine in 2005. Tested in master, AdventureWorks, and a couple other databases. What was the problem with it? It returns the table name, column name, and column type which should be enough.Fri, 06 Mar 2009 11:32:47 GMTGabyYYZRE: Finding all data types in user tableshttp://www.sqlservercentral.com/Forums/Topic581097-1373-1.aspxHi Gaby.If this script should run on MS SQL Server, you have to fix it first!!!!BR casFri, 05 Dec 2008 05:57:12 GMTCasyFinding all data types in user tableshttp://www.sqlservercentral.com/Forums/Topic581097-1373-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/SQL+Server+2005/64535/">Finding all data types in user tables</A>[/B]Mon, 06 Oct 2008 08:11:13 GMTGabyYYZ