public static List<SQLServerColumnInfo> getColumns(final Connection conn, final String schemaName,
            final String tableName) throws Exception {
        final String querySql = SQLServerSqlBuilder.buildDescTableSql(schemaName, tableName);
        final List<SQLServerColumnInfo> columnList = new ArrayList<>();
        try (Statement stmt = conn.createStatement();
                ResultSet rs = stmt.executeQuery(querySql)) {
            while (rs.next()) {
                SQLServerColumnInfo columnInfo = new SQLServerColumnInfo();
                columnInfo.setName(rs.getString(1));
                columnInfo.setType(rs.getString(2));
                columnInfo.setComment(rs.getString(3));
                columnList.add(columnInfo);
            }
        }
        return columnList;
    }
Query all columns of the tableName.

@param conn JDBC Connection  {@link Connection}
@param schemaName SQLServer schema name
@param tableName SQLServer table name
@return {@link List}
@throws Exception on get columns error
inlong-manager/manager-service/src/main/java/org/apache/inlong/manager/service/resource/sink/sqlserver/SQLServerJdbcUtils.java