基督.我有一个很好的格式化答案. IE崩溃时，我一直在滚动以点击保存.

Christ. i had a whole nicely formatted answer. i was scrolling to hit save when IE crashed.

简短版本:

对象属性

• TableFullTextPopulateStatus
• TableFullTextBackgroundUpdateIndexOn
• TableFullTextCatalogId
• TableFullTextChangeTrackingOn
• TableFullTextKeyColumn
• TableHasActiveFulltextIndex

TableFullTextBackgroundUpdateIndexOn 1 =真 0 =假

TableFullTextBackgroundUpdateIndexOn 1=TRUE 0=FALSE

TableFullTextPopulateStatus 0 =无人口 1 =人口总数 2 =增量人口

TableFullTextPopulateStatus 0=No population 1=Full population 2=Incremental population

完整示例:

SELECT
    --indicates whether full-text change-tracking is enabled on the table (0, 1)
    OBJECTPROPERTY(OBJECT_ID('DiaryEntry'), 'TableFullTextChangeTrackingOn') AS TableFullTextChangeTrackingOn,

    --indicate the population status of a full-text table (0=No population, 1=Full Population, 2=Incremental Population)
    OBJECTPROPERTY(OBJECT_ID('DiaryEntry'), 'TableFullTextPopulateStatus') AS TableFullTextPopulateStatus,

    --indicates whether a table has full-text background update indexing (0, 1)
    OBJECTPROPERTY(OBJECT_ID('DiaryEntry'), 'TableFullTextBackgroundUpdateIndexOn') AS TableFullTextBackgroundUpdateIndexOn,

    -- provides the full-text catalog ID in which the full-text index data for the table resides (0=table is not indexed)
    OBJECTPROPERTY(OBJECT_ID('DiaryEntry'), 'TableFullTextCatalogId') AS TableFullTextCatalogId,

    --provides the column ID of the full-text unique key column (0=table is not indexed)
    OBJECTPROPERTY(OBJECT_ID('DiaryEntry'), 'TableFullTextKeyColumn') AS TableFullTextKeyColumn,

    --indicates whether a table has an active full-text index (0, 1)
    OBJECTPROPERTY(OBJECT_ID('DiaryEntry'), 'TableHasActiveFulltextIndex') AS TableHasActiveFulltextIndex