Access Schema Information in SQL

SELECT * FROM INFORMATION_SCHEMA.TABLES
SELECT * FROM sysobjects


http://brainof-dave.blogspot.com/2006/11/xtype-values-in-sysobjects.html