Unfortunately I've deleted my database all tables but the size of the files(mdf, ldf) is not changed. I want to recover all the tables. Unfortunately, database backup not been taken. Please help me how to recover the deleted tables without taking any help of any software.
SQL Server keeps logs for each deleted record. You can query these logs via the fn_dblog SQL Server function.
SELECT [RowLog Contents 0] FROM sys.fn_dblog(NULL, NULL) WHERE AllocUnitName = 'dbo.TableName' AND Context IN ( 'LCX_MARK_AS_GHOST', 'LCX_HEAP' ) AND Operation in ( 'LOP_DELETE_ROWS' ) ; But this log is in Hex format and you need to convert this Hex format to your actual data.