List Only User Tables

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  September 23, 2007 at 11:09 am

  #198165

  Comments posted to this topic are about the item List Only User Tables

• RPSQL

  Hall of Fame

  Points: 3229

  More actions

  April 29, 2008 at 11:32 am

  #808575

  Easier one...njoi...

  USE [Databasename]

  GO

  SELECT [name] FROM sys.tables WHERE [type] = 'U'