How to compare the structures of two tables? - SQL Server Comparison Expert
Home > News > How to compare the structures of two tables?

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

Tag: compare table structure,compare database structures,table compare

Readers also visit these :

Related Questions :

Reviews & Award

  • "I love using this instead of gonig through the Microsoft wizard"

    - by John

  • "Reliable and simple to backup MSSQL, good for backup databases from one PC to another easily. "

    - by Paul