Show databases

SELECT name FROM sys.databases;

Show tables in database

SELECT * FROM SYSOBJECTS WHERE xtype = 'U';