Answer 1

For retrive special fields of a table you can run this

USE [Database Name]
SELECT COLUMN_NAME,*
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'YourTableName'

but if you want know its fields run this

SELECT *
FROM 'your table name'