且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何从现有的SQL Server快照/备份文件中获取表名和列名

更新时间:2023-02-03 13:21:02

我可能是错的,但是,我认为您可以直接从备份文件中读取文件,而无需将其附加到sql server引擎.您需要将其还原为临时数据库,然后才能从Select * From Information_Schema.TablesSelect * From Information_Schema.Columns视图中读取所有信息...
I might be wrong but, I dont think you can read from the backup file directly, without attaching it to the sql server engine. you need to restore somewhere as a temp database and then you can read all the information from Select * From Information_Schema.Tables and Select * From Information_Schema.Columns views...