select xx.name 'tableName', ac.name 'columnName', ac.column_id 'columnSeq', st.name 'columnType', 'referenceTable' = 	case 		when ac.name not IN ('VariationID', 'OperationID', 'CampaignID', 'ASNID') and RIGHT(ac.name,3) = 'NID'			then SUBSTRING(ac.name, 1, LEN(ac.name)-3) 		else null 	end from 	sys.all_columns ac join (	select		object_id,		name 	from 		sys.all_objects		where 		type_desc='USER_TABLE' 		and name not in (select name from sys.all_objects where type_desc='USER_TABLE' and name like 'MDML_%') 		and name not in ('CollectionDataRange','DataRange','DataRange_Locale', 'System_Parameters', 'GLPeriodBalance') ) xx on ac.object_id=xx.object_id join	sys.types st on ac.user_type_id=st.user_type_id order by 	xx.name, 	ac.column_id