Specifies the database tables or views involved in a SELECT statement.
table-expression:{ table-spec | table-expression join-type table-spec [ ON condition ] | ( table-expression [, …] ) }
table-spec:{ [ userid.] table-name [ [ AS ] correlation-name ] | select-statement [ AS correlation-name ( column-name [, …] ) ] }
contains-expression:{table-name | view-name } CONTAINS ( column-name [,...], contains-query ) [ [ AS ] score-correlation-name ]
contains-expression – use the CONTAINS clause after a table name to filter the table, and return only those rows matching the full text query specified with contains-query.
Every matching row of the table is returned, along with a score column that can be referred to using score-correlation-name, if it is specified. If score-correlation-name is not specified, then the score column can be referred to by the default correlation name, contains.
With the exception of the optional correlation name argument, the CONTAINS clause takes the same arguments as the CONTAINS search condition. There must be a TEXT index on the columns listed in the CONTAINS clause.