Finding all data types in user tables

• GabyYYZ

  SSCertifiable

  Points: 7913

  More actions

  October 6, 2008 at 8:11 am

  #193657

  Comments posted to this topic are about the item Finding all data types in user tables

  Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

• Casy

  Grasshopper

  Points: 21

  More actions

  December 5, 2008 at 5:57 am

  #908201

  Hi Gaby.

  If this script should run on MS SQL Server, you have to fix it first!!!!

  BR cas

• GabyYYZ

  SSCertifiable

  Points: 7913

  More actions

  March 6, 2009 at 11:32 am

  #955147

  casc (12/5/2008)

  ---

  Hi Gaby.

  If this script should run on MS SQL Server, you have to fix it first!!!!

  BR cas

  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.

  Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein