Listar las tablas y columnas de una base de datos - SQL Server

USE NombreDeLaBaseDeDatos

GO

SELECT SO.NAME, SC.NAME

FROM sys.objects SO INNER JOIN sys.columns SC

ON SO.OBJECT_ID = SC.OBJECT_ID

WHERE SO.TYPE = 'U'

ORDER BY SO.NAME, SC.NAME