search

reddyvuppula / websitereflectionnetin

0 stars 0 forks source link

Delete tables not being used #60

Open kjanwadker opened 2 months ago

kjanwadker commented 2 months ago

1) If these tables are not being used (I don't think they are) then no need to create in the new database. Update the scripts accordingly.

[SDD_LTRAK].[dbo].[LTRAKUSERS] [SDD_LTRAK].[dbo].[LTRAKSALUTATIONS] [SDD_LTRAK].[dbo].[LTRAKREQORIGINS] [SDD_LTRAK].[dbo].[LTRAKLETTERS] [SDD_LTRAK].[dbo].[LTRAKCUSTGROUPS] [SDD_LTRAK].[dbo].[LTRAKCTRL]

reddyvuppula commented 2 months ago

--Not using [SDD_LTRAK].[dbo].[LTRAKUSERS] [SDD_LTRAK].[dbo].[LTRAKSALUTATIONS] [SDD_LTRAK].[dbo].[LTRAKCUSTGROUPS]

----In use [SDD_LTRAK].[dbo].[LTRAKCTRL] -- While add/update request we log some history in table [SDD_LTRAK].[dbo].[LTRAKREQORIGINS] -- We listing request Origins dropdown on create/edit request form [SDD_LTRAK].[dbo].[LTRAKLETTERS] -- Getting word template for print the report

kjanwadker commented 2 months ago

If those 3 tables are not being used then update the script not to create (and import) those 3 tables in the new database.