如何从现有的SQL Server快照/备份文件中获取表名和列名 [英] How to get table and column names from existing sql server snapshot/backup file

问题描述

我们正在设计Windows应用程序，我们需要在其中从现有的sql server快照文件或备份文件中获取表名和列名".
有人知道该怎么做吗?

请提供帮助.
谢谢你. :)

Hi,
We are designing a windows application where we need to ''Get table and column names from existing sql server snapshot file or backup file'' .
Does anybody know how it can be done.

Please provide help.
Thank you. :)

推荐答案

我可能是错的，但是，我认为您可以直接从备份文件中读取文件，而无需将其附加到sql server引擎.您需要将其还原为临时数据库，然后才能从Select * From Information_Schema.Tables和Select * 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...

这篇关于如何从现有的SQL Server快照/备份文件中获取表名和列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！