Show pageBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== List Out All Tables and Fields ====== <code> SELECT TABLE_SCHEMA , TABLE_NAME , COLUMN_NAME , ORDINAL_POSITION , COLUMN_DEFAULT , DATA_TYPE , CHARACTER_MAXIMUM_LENGTH , NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX , NUMERIC_SCALE , DATETIME_PRECISION FROM INFORMATION_SCHEMA.COLUMNS; </code> ref: [[https://stackoverflow.com/questions/420741/getting-list-of-tables-and-fields-in-each-in-a-database]] ms_sql_server/list_out_all_tables_and_fields.txt Last modified: 2019/01/23 10:39by chongtin