SELECT * FROM INFORMATION_SCHEMA.TABLES
SELECT TABLE_CATALOG+'.'+TABLE_SCHEMA+'.'+TABLE_NAME tablename,COLUMN_NAME columnname FROM INFORMATION_SCHEMA.COLUMNS
select
sys.schemas.name, sys.objects.name
from sys.objects,
sys.schemas
where sys.objects.type='U'
and sys.objects.schema_id=sys.schemas.schema_id