A query to get all table and column definitions for a database

Get_Table_Column_Definitions.sql

select distinct
	ROW_NUMBER() over (Order by s.name, t.name) as Id, 
	s.name as SchemaName,
	t.name as TableName,
	c.name as ColumnName,
	typ.name as DataType,
	case c.precision
		when 0 then 'Max'
		else cast(c.precision as nvarchar(75))
	end as DataTypeValue,
	c.is_identity as IsPrimaryKey
from 
	sys.tables t
inner join
	sys.schemas s on t.schema_id = s.schema_id
inner join
	sys.columns c on c.object_id = t.object_id
inner join
	sys.types typ on c.user_type_id = typ.user_type_id
order by
	s.name, t.name