You are here: Home > FAQ > FAQ More

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.

compare_processing

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.

structure_column

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:

structure_index

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.

create_script

: How to synchronize automatically?
: How many database objects you can choose?


Tags: compare table structure   compare database structures   table compare  

Readers also visit these:

What is data, database (DB), DBMS and DBS?
How to compare and synchronize the data in different database tables?
Which license is best for me?
How to install Database Compare in my local disk?
What is foreign key?

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?