Helps you to find tables and data structure infos

SqlServer_TablesColumnsInfo.sql

SELECT 	
	o.Name 'Table Name',	
    c.name 'Column Name',
    t.Name 'Data type',
    c.max_length 'Max Length',
    c.precision ,
    c.scale ,
    c.is_nullable
FROM  sys.columns c
INNER JOIN  sys.types t ON c.user_type_id = t.user_type_id
INNER JOIN sys.objects o ON c.object_id = 	o.object_id
WHERE o.type = 'U'  AND o.Name  LIKE 'JOB%'
ORDER BY o.Name ASC

-- Get columns and table names who table name start with 'JOB'