Following query gives complete list of tables and views in a SQL database.
USE [DATABASE NAME]
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
Following is the sample query to get column names and data types for selected table:
COLUMN_NAME 'COLUMN NAME',
DATA_TYPE 'DATA TYPE',
COULMN_DEFAULT 'COLUMN DEFAULT'
WHERE TABLE_NAME = 'TABLE NAME'