我可以使用哪个 SQL 命令来查看 SQL Server 上表的结构?

本文介绍了我可以使用哪个 SQL 命令来查看 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'

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