|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-26 : 20:35:27
|
Curtis writes "I am in need of finding (programatically) the tables and fields that are included in a full text catalog..by catalog name. I have tried to join system tables but I don't know the field names that hold that ticket. Does anyone know the joins involved to find the specific fields involved in each catalog?
I need to generate a script that will build the FTC's for me programatically. I currently rely on SQL scripting to provide that for me..but I want to avoid that manual step. I know how to start with the sysfulltextCatalogs table..but its from that point that I want to join the tables necessary to give me all the field names I need.
If the enterprise manager can script EACH piece of a FTC.. there should be a way to do it programatically.
I will also have to deal with any foreign keys involved with each FTC table if that other table also has a FTC.. and any help with that logic would be highly appreciated
Here is an example of what I want to be able to build programatically..
exec sp_fulltext_catalog N'Candidates_FTC', N'create'
exec sp_fulltext_table N'[dbo].[CandidatePositionDetails]', N'activate'
GO
exec sp_fulltext_table N'[dbo].[Candidates]', N'create', N'Candidates_FTC', N'PK_Candidates'
GO
exec sp_fulltext_column N'[dbo].[Candidates]', N'IntSchedContact', N'add'
GO
exec sp_fulltext_column N'[dbo].[Candidates]', N'IntSchedContactPhone', N'add'
GO
exec sp_fulltext_column N'[dbo].[Candidates]', N'EmployeeID', N'add'
GO
exec sp_fulltext_column N'[dbo].[Candidates]', N'OfficePhone', N'add'
GO
exec sp_fulltext_column N'[dbo].[Candidates]', N'OfficeEMail', N'add'
GO
exec sp_fulltext_column N'[dbo].[Candidates]', N'Location', N'add'
GO
exec sp_fulltext_column N'[dbo].[Candidates]', N'HireOffer', N'add'
GO
exec sp_fulltext_column N'[dbo].[Candidates]', N'AllowChange', N'add'
GO
exec sp_fulltext_column N'[dbo].[Candidates]', N'DocType', N'add'
GO
exec sp_fulltext_table N'[dbo].[Candidates]', N'activate'
GO
exec sp_fulltext_table N'[dbo].[CandidateShow]', N'create', N'Candidates_FTC', N'PK_CandidateShow'
GO
exec sp_fulltext_column N'[dbo].[CandidateShow]', N'CandidateStatus', N'add'
GO
exec sp_fulltext_column N'[dbo].[CandidateShow]', N'ShowHire', N'add'
GO
exec sp_fulltext_column N'[dbo].[CandidateShow]', N'ShowHireUndo', N'add'
GO
exec sp_fulltext_column N'[dbo].[CandidateShow]', N'ShowDisposition', N'add'
GO
exec sp_fulltext_column N'[dbo].[CandidateShow]', N'ShowInterview', N'add'
GO
exec sp_fulltext_column N'[dbo].[CandidateShow]', N'ShowOffer', N'add'
GO
exec sp_fulltext_column N'[dbo].[CandidateShow]', N'OfferStatus', N'add'
GO
exec sp_fulltext_column N'[dbo].[CandidateShow]', N'HireUndoReason', N'add'
GO
exec sp_fulltext_column N'[dbo].[CandidateShow]', N'DispositionType', N'add'
GO
exec sp_fulltext_column N'[dbo].[CandidateShow]', N'DispositionReason', N'add'
GO
exec sp_fulltext_column N'[dbo].[CandidateShow]', N'DispositionUndoReason', N'add'
GO
exec sp_fulltext_table N'[dbo].[CandidateShow]', N'activate'
GO
Thank you
Curtis
" |
|
Full text index