how do I query the operation log? for example: user operation of database(like create,drop..)，user operation of table(insert,delete,update))

Question

how do I query the operation log? for example: user operation of database(like create,drop..)，user operation of table(insert,delete,update).

Answer 1

As in your other post: https://learn.microsoft.com/en-us/answers/questions/415651/sqlserver-operation.html
If you haven't implemented a logging/Auditing, then you can not get the informations afterwards.

You can use e.g. trigger to log DML operations lik INSERT, see CREATE TRIGGER (Transact-SQL)