How to find out who has loaded the table recently ?

Database

How to find out who has loaded the table recently ?

Hi there ..

Just I want to know who has loaded the table recently. Which system table gives this details ?

Thanks
Vel.
2 REPLIES
Enthusiast

Re: How to find out who has loaded the table recently ?

Check this.

SELECT TOP 1 username,extrafield5, defaultdatabase
FROM dbc.DBQLogTbl
WHERE querytext LIKE '%INSERT into USER
ORDER BY queryid DESC
Enthusiast

Re: How to find out who has loaded the table recently ?

Or take a look at the dbc.tablesx. check to see what time and which accout created that table. But this way you can only know the table strcture changes of a specific table. For insert statement, you have to look at the DBQL tables if you have account logged turn on.