This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › Microsoft SQL Server › MS SQL SERVER exports table structures to Excel
View: 18096|Reply: 3

[Source] MS SQL SERVER exports table structures to Excel

[Copy link]
Posted on 3/15/2018 5:27:32 PM | | | |
Today, I am going to sort out several databases in my hand to form a table structure document for future maintenance and use.

I found a script on the Internet that was not bad, and a small modification met my requirements, and the SQL script was executed.

At this time, you only need to choose to export CSV, and then create a new Excel table, select the data in the menu bar, and then select from text, and then you can process it yourself according to your own needs.

SQL Server scripts:




All query results are selected, right-click "Save Result As"



Then save the file in csv format, and the file will open as follows:







Previous:Git method to completely delete historical commit records
Next:PowerShell technical documentation download

Related Posts
Posted on 3/16/2018 11:00:19 AM |
Hehe, it's really good
Posted on 4/24/2018 2:18:12 PM |
Collect it, and you should use it then
Posted on 8/10/2020 9:01:55 AM |
MySQL database name, table name, and field name query
https://www.itsvse.com/thread-6866-1-1.html
(Source: Architect_Programmer)
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com