SELECT TABLE_SCHEMA + '.' + TABLE_NAME [Table Name], * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' ORDER BY 1
Login to post response