SHOW TABLES isn't compatible with MSSQL. Query against the internal sysobjects table and filter by user tables ( type = 'u' ). Note: type = 'u' is used only for semantic purposes.