本文介绍了我可以使用哪个 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
更多推荐
我可以使用哪个 SQL 命令来查看 SQL Server 上表的结构?
发布评论