我可以使用哪个 SQL 命令来查看 SQL Server 上表的结构? [英] Which SQL command can I use to see the structure of a table on SQL Server?

问题描述

我在 SQL Server 上有一个表，我想导出它的结构以发送给同事.我应该发出哪个 SQL 命令来获取结构?我无权访问 SQL Server Management Studio.

I have a table on a SQL Server and I would like to export its structure to send to a colleague. Which SQL command should I issue to get the structure? I don't have access to the SQL Server Management Studio.

推荐答案

sp_help '<TableName>'

会给你一个表格的结构

也可以使用information_Schema来获取详细信息，

Also you can use the information_Schema to get a detailed information,

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableName' 

检查一下 http://msdn.microsoft.com/en-us/library/ms186778.aspx

这篇关于我可以使用哪个 SQL 命令来查看 SQL Server 上表的结构?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！