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

Advertisements