List Out All Tables and Fields

 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;

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:39
  • by chongtin