SELECT * FROM sysobjects WHERE type = 'U'

SELECT * FROM INFORMATION_SCHEMA.TABLES