0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people interested in the history and origins of science and mathematics

select
  table_name as [Table(Links to Sample Data)], --sample data subquery
  ordinal_position as [Field #],
  column_name as [Column],
  (case
    when data_type like '%varchar%'
      then data_type+'('+cast(character_maximum_length as varchar)+')'
    else
      data_type
      end) + 
      (case when IS_NULLABLE like '%NO%' then ' not null' else '' end)  as [type]
from information_schema.columns
--where table_name like '%Types%' --ⓘuncomment this line to limit to reference tables
order by table_name, ordinal_position

---------------------------------------------------------------------
--SEDE Fields not included since all records always have these value:
--  TABLE_SCHEMA            = 'dbo'
--  COLUMN_DEFAULT          = Null
--  DATETIME_PRECISION      = 3 (when DATETIME)
--  NUMERIC_PRECISION_RADIX = (when TINYINT, SMALLINT, INT)
--  NUMERIC_SCALE           = Null
---------------------------------------------------------------------

-- ⓘ=tables ending with '%Types' are static reference tables

fork query

edited dec 4

created dec 4 anonymous