Find Tables List Structure Count Duplicate Records
use <database_name> Select DataBase using above query select * from information_schema.tables You can easily fine tables list using above syntax. sp_help <table_name> See particular table structure/Design. select s_order_no, count(s_order_no) As ‘SalesOrder’ from sales_order_details group by s_order_no…
Read More