Guest User

Untitled

a guest
Nov 17th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. SELECT
  2. distinct t.name AS TableName
  3. FROM
  4. sys.tables t
  5. INNER JOIN
  6. sys.fulltext_indexes fi
  7. ON
  8. t.[object_id] = fi.[object_id]
  9. INNER JOIN
  10. sys.fulltext_index_columns ic
  11. ON
  12. ic.[object_id] = t.[object_id]
  13. INNER JOIN
  14. sys.columns cl
  15. ON
  16. ic.column_id = cl.column_id
  17. AND ic.[object_id] = cl.[object_id]
  18. INNER JOIN
  19. sys.fulltext_catalogs c
  20. ON
  21. fi.fulltext_catalog_id = c.fulltext_catalog_id
  22. INNER JOIN
  23. sys.indexes i
  24. ON
  25. fi.unique_index_id = i.index_id
  26. AND fi.[object_id] = i.[object_id];
Add Comment
Please, Sign In to add comment