SHOW COLUMNS FROM table_name
SELECT
TABLE_NAME
FROM
INFORMATION_SCHEMA.TABLES
sp_columns feeAgreement
-- or
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'feeAgreement'
-- You can select data from a table using a SELECT statement.
-- Select all columns from table:
SELECT *
FROM example_table;
SELECT * FROM contacts;
select * from <table-name>;