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 having (count(s_order_no)>1)
Find Duplicate Records In Table