Home Forums SQL Server 2005 Administering Select RE: Select

  • April 13, 2009 at 1:31 pm

    #976852

    ALZDBA (4/13/2009)

    INFORMATION_SCHEMA views also work with pre sql2005 versions.

    To only select actual tables you need to add the where clause

    Where TABLE_TYPE = 'BASE TABLE'

    thx. i didn't mean to imply that it wouldn't.