To compare the differences of two tables, first you need to connect to the sql database server, then you can go through the following steps.
Step 1: Choose the tables which you want to compare. Click the "Compare" button, to begin the comparison process ofÂ table structure.
Step 2: After comparison, you can find the result of the structure of two tables. Click "Column" you will find the differences in the field of table.
Step 3: Click "Index", you can view the differences about primary key of two tables. Also you can click "ForeignKey", "Constrains", "Permission" to find other differences, here you will find no differences. Specification show you below:
Step 4: Click "Script" you will find that the different contrast resultsÂ were marked as red. Here, the script is the statement that used to creat a table.