Post reply

Find Numeric data - All tables

  • April 24, 2005 at 8:21 am

    #88248

    I started another thread, my original question was too confusing

  • April 25, 2005 at 8:12 am

    #554591

    how about some thing like :

    select sysobjects.name. syscolumns.name

    from sysobjects obj, syscolumns col

    where col.type = 108          -- {numeric datastype}

  • April 25, 2005 at 10:04 am

    #554643

    select

          TABLE_NAME, COLUMN_NAME

    from

          INFORMATION_SCHEMA.COLUMNS

    where

          NUMERIC_PRECISION IS NOT NULL


    * Noel

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply