Here is a query which can fetch all the table names and all the colunm names in each table.
select table_name, column_name, data_type, character_maximum_length, is_nullable from information_schema.columns where table_name in (select name from sysobjects where xtype='U') order by table_name
# re: SQL Query to list down the tables and all coumhs in database,
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,
# re: SQL Query to list down the tables and all coumhs in database,