MSSQL Tables of DB or Fields of Tables

For Fields

SELECT * FROM yourDBName.INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = N'yourTableName'


For Tables

SELECT * FROM yourDBName.INFORMATION_SCHEMA.TABLES