405
Does anyone know all of the "around 70" tables that were uptaded to contain the DEX_ROW_TS coulumn in SP4? I have found three tables:
GL00100
IV00107
RM00101
-Jody
*This post is locked for comments
Run this against your company database:
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%DEX_ROW_TS%'
ORDER BY schema_name, table_name;
I got these results (36 tables)
GL00100
GL10000
GL12000
GL20000
GL30000
GL32000
IV00101
IV00107
IV00108
IV10000
IV30200
IV40201
IV40202
IV40800
PM00200
PM00300
PM10000
PM20000
PM30200
POP10100
POP10110
POP30100
POP30110
RM00101
RM00102
RM00301
RM00303
RM10301
RM20101
RM30101
SOP10100
SOP10200
SOP30200
SOP30300
SY01200
UPR00100
Tim
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (