Post reply

Script to list table definition posted by kirbyr

  • June 9, 2006 at 2:48 am

    #117938

    Lovely script but one (minor) problem caused a few headaches. If the database name needs to be bracketed e.g. [2005] then it fails.

    The line

    FROM " + @dbname +".INFORMATION_SCHEMA.COLUMNS

    needs to read

    

    FROM [" + @dbname +"].INFORMATION_SCHEMA.COLUMNS
    

    to cope with this. 
     
      
    •  
  •   
     
     
     June 9, 2006 at 8:27 pm 
     
      #642948  
          
         
     
    I'm thinking this is a bit of an orphan post...
    --Jeff Moden 
    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    Change is inevitable... Change for the better is not.
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
     
      
    •  
Viewing 2 posts - 1 through 1 (of 1 total)
 
You must be logged in to reply to this topic. Login to reply