{"id":3052,"date":"2011-10-12T16:18:12","date_gmt":"2011-10-12T15:18:12","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=3052"},"modified":"2019-09-13T14:33:41","modified_gmt":"2019-09-13T13:33:41","slug":"regenerer-le-ddl-des-indexes-full-text","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/","title":{"rendered":"Reg\u00e9n\u00e9rer le DDL des indexes FULL TEXT"},"content":{"rendered":"<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F3052&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F3052&#038;title=Reg%C3%A9n%C3%A9rer%20le%20DDL%20des%20indexes%20FULL%20TEXT\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Reg%C3%A9n%C3%A9rer%20le%20DDL%20des%20indexes%20FULL%20TEXT&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F3052\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a><p>Comme il n&#8217;y a pas d&#8217;outil pour le faire et que j&#8217;ai d\u00fb le faire pour un client r\u00e9cemment (ne fonctionne qu&#8217;\u00e0 partir de SQL Server 2008+):<\/p>\n<pre><span style=\"color: #0000ff;\">use mabase ;\r\n\r\n<\/span><span style=\"color: #0000ff;\">create table #ftsDDL (catalogname sysname, objname sysname, objtype varchar(20),\r\ncolname sysname, type_column_id sysname NULL, langid int, indexname sysname,\r\nchangetracking varchar(10), stoplistname sysname)\r\n\r\ninsert into #ftsDDL\r\nselect FTC.name 'Catalog Name', T.name 'Object name', 'Table' 'Object Type',\r\nC.name 'colname', FTIC.type_column_id, FTIC.language_id, I.name 'UQIndexName',\r\nFTI.change_tracking_state_desc,\r\ncase when STP.name &lt;&gt; '0' then STP.name else 'system' end\r\nfrom sys.fulltext_indexes FTI\r\ninner join sys.fulltext_catalogs FTC on FTC.fulltext_catalog_id = FTI.fulltext_catalog_id\r\ninner join sys.tables T on FTI.object_id = T.object_id\r\ninner join sys.indexes I on I.object_id = T.object_id\r\ninner join sys.fulltext_index_columns FTIC on FTIC.object_id = FTI.object_id\r\ninner join sys.columns C on C.column_id = FTIC.column_id and C.object_id = FTI.object_id\r\nleft outer join sys.fulltext_stoplists STP on STP.stoplist_id = FTI.stoplist_id\r\nwhere I.is_unique = 1 and I.type = 1\r\nand FTIC.type_column_id is NULL\r\n\r\n\t UNION \r\n\r\nselect FTC.name 'Catalog Name', V.name 'Object name', 'Indexed View' 'Object Type',\r\nC.name 'colname', FTIC.type_column_id, FTIC.language_id, I.name 'UQIndexName',\r\nFTI.change_tracking_state_desc,\r\ncase when STP.name &lt;&gt; '0' then STP.name else 'system' end\r\nfrom sys.fulltext_indexes FTI\r\ninner join sys.fulltext_catalogs FTC on FTC.fulltext_catalog_id = FTI.fulltext_catalog_id\r\ninner join sys.views V on FTI.object_id = V.object_id\r\ninner join sys.indexes I on I.object_id = V.object_id\r\ninner join sys.fulltext_index_columns FTIC on FTIC.object_id = FTI.object_id\r\ninner join sys.columns C on C.column_id = FTIC.column_id and C.object_id = FTI.object_id\r\nleft outer join sys.fulltext_stoplists STP on STP.stoplist_id = FTI.stoplist_id\r\nwhere I.is_unique = 1 and I.type = 1\r\nand FTIC.type_column_id is NULL\r\norder by 1;\r\n\r\nwith cte as\r\n (select p1.catalogname, p1.objname, (select colname\r\n +case\r\nwhen p2.type_column_id is NULL then '' else ' TYPE COLUMN *put type column here*' end+\r\n' language '+cast(p2.langid as char(5))+','\r\nfrom #ftsDDL p2 where p1.objname = p2.objname FOR XML PATH ('') ) as 'Columns',\r\np1.indexname, p1.changetracking, p1.stoplistname from #ftsDDL p1 group by catalogname,\r\nobjname, indexname, changetracking, stoplistname\r\n)\r\n\r\nselect 'CREATE FULLTEXT INDEX ON '+objname+'('+substring(Columns,1,len(Columns)-1)+\r\n') KEY INDEX ['+indexname+'] on ['+catalogname+'] WITH CHANGE_TRACKING '+changetracking+\r\n', STOPLIST = ['+stoplistname+']' from cte;\r\n\r\ndrop table #ftsDDL;<\/span><\/pre>\n<pre><span style=\"color: #008000;\">\/*<\/span><\/pre>\n<pre><span style=\"color: #008000;\">CREATE FULLTEXT INDEX ON V_ContentItmListGermany(abstr language 1031 ,desc language 1031 ,\r\nsubt language 1031 ,title language 1031 ) KEY INDEX [UI_V_ContentItmsListGermany]\r\non [Catalog_1] WITH CHANGE_TRACKING AUTO, STOPLIST = [SYSTEM]<\/span><\/pre>\n<pre><span style=\"color: #008000;\">CREATE FULLTEXT INDEX ON V_GenAtttGermany(blob language 1031 ) KEY INDEX [UI_V_GenAtttGermany]\r\non [Catalog_1] WITH CHANGE_TRACKING AUTO<\/span><span style=\"color: #008000;\">, STOPLIST = [SYSTEM]<\/span><span style=\"color: #008000;\">\r\n\r\n<\/span><span style=\"color: #008000;\">CREATE FULLTEXT INDEX ON V_GenAttachmentDe(blob TYPE COLUMN <span style=\"color: #ff0000;\">*put type column here*<\/span>\r\nlanguage 1031 ) KEY INDEX  [UI_V_GenAttachmentDe] on [Catalog_LanDe]\r\nWITH CHANGE_TRACKING AUTO<\/span><span style=\"color: #008000;\">, STOPLIST = [SYSTEM]<\/span><\/pre>\n<pre><span style=\"color: #008000;\">CREATE FULLTEXT INDEX ON V_GenAtttUS(blob language 1033 ) KEY INDEX [UI_V_GenAtttUS]\r\non [Catalog_2] WITH CHANGE_TRACKING AUTO<\/span><span style=\"color: #008000;\">, STOPLIST = [SYSTEM]<\/span><\/pre>\n<pre><span style=\"color: #008000;\">CREATE FULLTEXT INDEX ON V_GenAttachmentEn(blob TYPE COLUMN <span style=\"color: #ff0000;\">*put type column here*<\/span>\r\nlanguage 1033 ) KEY INDEX  [UI_V_GenAttachmentEn] on [Catalog_LanEn]\r\nWITH CHANGE_TRACKING AUTO<\/span><span style=\"color: #008000;\">, STOPLIST = [SYSTEM]<\/span><span style=\"color: #008000;\">\r\n\r\nCREATE FULLTEXT INDEX ON V_GenAtttFrance(blob language 1036 ) KEY INDEX [UI_V_GenAtttFrance]\r\non [Catalog_3] WITH CHANGE_TRACKING AUTO<\/span><span style=\"color: #008000;\">, STOPLIST = [SYSTEM]<\/span><\/pre>\n<p><span style=\"color: #008000;\">*\/<\/span><\/p>\n<p>Les indexes FTS, contraitement aux catalogues ne peuvent pas \u00eatre script\u00e9s directement dans SSMS. Evidemment il faudra recr\u00e9er les catalogues avant. Attention, si des colonnes index\u00e9es sont de type varbinary(max) ou image, il faudra pr\u00e9ciser le nom de la colonne qui stocke l&#8217;extension (cf <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms187317.aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/ms187317.aspx<\/a>) \u00e0 la place de<span style=\"color: #ff0000;\"> <em>*put type column here*<\/em><br \/>\n<span style=\"color: #000000;\">(je ne peux pas les deviner)<\/span><br \/>\n<\/span><\/p>\n<p>Petite note int\u00e9ressante, dans le cas de ce client, les indexes FTS \u00e9taient cr\u00e9\u00e9s sur des vues index\u00e9es, d&#8217;o\u00f9 l&#8217;UNION entre les indexes li\u00e9s \u00e0 sys.tables et ceux li\u00e9s \u00e0 sys.views dans la table temporaire. Et pour transposer et concat\u00e9ner les colonnes de l&#8217;index sur une ligne on utilise la technique avec FOR XML PATH(&#8221;) dans la CTE.<\/p>\n<p>A+<\/p>\n<div id=\"_mcePaste\" style=\"overflow: hidden; position: absolute; left: -10000px; top: 2px; width: 1px; height: 1px;\">\n<pre><span style=\"color: #008000;\">ContentItmListGermany<\/span><\/pre>\n<\/div>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F3052&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F3052&#038;title=Reg%C3%A9n%C3%A9rer%20le%20DDL%20des%20indexes%20FULL%20TEXT\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Reg%C3%A9n%C3%A9rer%20le%20DDL%20des%20indexes%20FULL%20TEXT&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F3052\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>Comme il n&#8217;y a pas d&#8217;outil pour le faire et que j&#8217;ai d\u00fb le faire pour un client r\u00e9cemment (ne fonctionne qu&#8217;\u00e0 partir de SQL Server 2008+): use mabase ; create table #ftsDDL (catalogname sysname, objname sysname, objtype varchar(20), colname&hellip; <a href=\"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/\" class=\"more-link\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":7904,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[210],"class_list":["post-3052","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","tag-fulltext"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Reg\u00e9n\u00e9rer le DDL des indexes FULL TEXT - Capdata TECH BLOG<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reg\u00e9n\u00e9rer le DDL des indexes FULL TEXT - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Comme il n&#8217;y a pas d&#8217;outil pour le faire et que j&#8217;ai d\u00fb le faire pour un client r\u00e9cemment (ne fonctionne qu&#8217;\u00e0 partir de SQL Server 2008+): use mabase ; create table #ftsDDL (catalogname sysname, objname sysname, objtype varchar(20), colname&hellip; Continuer la lecture &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-12T15:18:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-13T13:33:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2011\/10\/FT.png\" \/>\n\t<meta property=\"og:image:width\" content=\"649\" \/>\n\t<meta property=\"og:image:height\" content=\"454\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"David Baffaleuf\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Baffaleuf\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/\"},\"author\":{\"name\":\"David Baffaleuf\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\"},\"headline\":\"Reg\u00e9n\u00e9rer le DDL des indexes FULL TEXT\",\"datePublished\":\"2011-10-12T15:18:12+00:00\",\"dateModified\":\"2019-09-13T13:33:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/\"},\"wordCount\":172,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"fulltext\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/\",\"name\":\"Reg\u00e9n\u00e9rer le DDL des indexes FULL TEXT - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2011-10-12T15:18:12+00:00\",\"dateModified\":\"2019-09-13T13:33:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reg\u00e9n\u00e9rer le DDL des indexes FULL TEXT\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\",\"name\":\"David Baffaleuf\",\"sameAs\":[\"http:\/\/www.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/dbaffaleuf\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reg\u00e9n\u00e9rer le DDL des indexes FULL TEXT - Capdata TECH BLOG","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/","og_locale":"fr_FR","og_type":"article","og_title":"Reg\u00e9n\u00e9rer le DDL des indexes FULL TEXT - Capdata TECH BLOG","og_description":"Comme il n&#8217;y a pas d&#8217;outil pour le faire et que j&#8217;ai d\u00fb le faire pour un client r\u00e9cemment (ne fonctionne qu&#8217;\u00e0 partir de SQL Server 2008+): use mabase ; create table #ftsDDL (catalogname sysname, objname sysname, objtype varchar(20), colname&hellip; Continuer la lecture &rarr;","og_url":"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2011-10-12T15:18:12+00:00","article_modified_time":"2019-09-13T13:33:41+00:00","og_image":[{"width":649,"height":454,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2011\/10\/FT.png","type":"image\/png"}],"author":"David Baffaleuf","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"David Baffaleuf","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/"},"author":{"name":"David Baffaleuf","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf"},"headline":"Reg\u00e9n\u00e9rer le DDL des indexes FULL TEXT","datePublished":"2011-10-12T15:18:12+00:00","dateModified":"2019-09-13T13:33:41+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/"},"wordCount":172,"commentCount":0,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["fulltext"],"articleSection":["SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/","url":"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/","name":"Reg\u00e9n\u00e9rer le DDL des indexes FULL TEXT - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2011-10-12T15:18:12+00:00","dateModified":"2019-09-13T13:33:41+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/regenerer-le-ddl-des-indexes-full-text\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"Reg\u00e9n\u00e9rer le DDL des indexes FULL TEXT"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf","name":"David Baffaleuf","sameAs":["http:\/\/www.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/dbaffaleuf\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/3052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=3052"}],"version-history":[{"count":50,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/3052\/revisions"}],"predecessor-version":[{"id":7905,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/3052\/revisions\/7905"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7904"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=3052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=3052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=3052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}