• Easier one...njoi...

    USE [Databasename]

    GO

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