方法一：
SELECT

   *

FROM FTCE_ACCS.INFORMATION_SCHEMA.TABLES

Where

    TABLE_TYPE='BASE TABLE'
------------------------------------------------------------------------------------------------------
方法二：
SELECT Name FROM sysobjects WHERE TYPE='U'