打印表的结构/模式 [英] Printing Table's structure/schema

问题描述

我在数据库中有20个左右的表，而且我想打印出来（物理上），所以我可以更容易地看看它们。我不太在意他们的数据，只是他们的结构。我该怎么做？

I have like 20 or so tables in the database RentalEase and I want to print them out (physically) so I can look at them easier. I don't care too much about what data is in them, just their structure. How can I do this?

这是一个SQL Express服务器，我正在使用Microsoft SQL Server Management Studio Express进行管理。我记得当我使用MySQL和PHP时，我可以使用DESCRIBE来打印出来，但我不记得我是如何做到的。对于SQL Server来说似乎没有DESCRIBE

It's an SQL Express server and I'm using Microsoft SQL Server Management Studio Express to manage it. I remember back when I was using MySQL and PHP I could use a DESCRIBE to print it out but I don't remember how I did it. There doesn't seem to be a DESCRIBE for SQL Server

推荐答案

尝试：

sp_help <table_name>

这篇关于打印表的结构/模式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！