How to compare the structures of two tables?
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.

Tags: compare table structure compare database structures table compare
Readers also visit these:
How to compare and synchronize the data in different database tables?Which license is best for me?
How can I get technical support?
How to install Database Compare in my local disk?
How to compare and synchronize the differences of two database triggers?
Related Questions:
What is Database Integrity?What is foreign key?
What is data, database (DB), DBMS and DBS?
What is role?
What is data backup and data recovery?
Technical Support
Latest News
- Can you show me the ...
- How to compare and s...
- How to compare and s...
- How to compare and s...
- How to compare and s...
- Which license is bes...
Awards
Customer Service |
| If you have any question or suggestion,please contact us. |
| Get Help>> |
:
: 

