Coul anyone tell me how to open a closed project from backend using sql scripts. What all tables need to be updated for that.
Thanks in advance.
Use the front-end reopen button on the request by setting the reopen step on the workflow.
I don't know about from SQL, but if you need to automate this somehow you could probably use the ksc_move_request_workflow special command with FORCE_TRANSITION option to bump it to whatever step you want. Look in the commands guide for more info.