public static String buildDescTableSql(final String schemaName, final String tableName) {
        final StringBuilder sql = new StringBuilder()
                .append(" SELECT C.COLUMN_NAME AS NAME,C.DATA_TYPE AS TYPE,CAST(D.VALUE AS VARCHAR) AS COMMENT FROM ")
                .append("(SELECT B.OBJECT_ID,A.TABLE_NAME,A.COLUMN_NAME,A.DATA_TYPE,A.ORDINAL_POSITION")
                .append(" FROM INFORMATION_SCHEMA.COLUMNS A LEFT JOIN SYS.TABLES B")
                .append(" ON A.TABLE_NAME = B.NAME")
                .append("  WHERE A.TABLE_NAME = '")
                .append(tableName)
                .append("'  AND A.TABLE_SCHEMA = '")
                .append(schemaName)
                .append("') C  LEFT JOIN SYS.EXTENDED_PROPERTIES D")
                .append(" ON C.OBJECT_ID = D.MAJOR_ID ")
                .append(" AND C.ORDINAL_POSITION = D.MINOR_ID ;");
        LOGGER.info("desc table sql={}", sql);
        return sql.toString();
    }
Build query table SQL.

@param schemaName SQLServer schema name
@param tableName SQLServer table name
@return desc table SQL string
inlong-manager/manager-service/src/main/java/org/apache/inlong/manager/service/resource/sink/sqlserver/SQLServerSqlBuilder.java