如何在SQL Server的其他数据库中检查数据库中表的所有列到同一个表 [英] How to check all column of a table in a database to same table exist in other databases in SQL server

问题描述

I have a table in a database and I have same table to other databases.I add some columns of the table of first database.Now I want to check that all off database's table are same or not.If its not then add those columns on those tables.Please give any kind of writing sp or another idea to do that

我尝试了什么：



我没有尝试任何东西，因为我不知道怎么做

What I have tried:

I have tried nothing because I dont have idea how to do that

推荐答案

您可以使用SQL Server数据工具中的模式比较来构建迁移脚本

you can use the schema compare in SQL Server data tools to build a migration script

这篇关于如何在SQL Server的其他数据库中检查数据库中表的所有列到同一个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！