---

SELECT
    TABLE_NAME,
    COLUMN_NAME,
    DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME IN
    (N'Роль', N'физическое лицо', N'сотрудник', N'Заявка', N'Вход')
ORDER BY TABLE_NAME, ORDINAL_POSITION;