How can I show the table structure in SQL Server query?
2021/6/21 19:29:45
本文主要是介绍How can I show the table structure in SQL Server query?,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
How can I show the table structure in SQL Server query?
回答1
For SQL Server, if using a newer version, you can use
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='tableName'
There are different ways to get the schema. Using ADO.NET, you can use the schema methods. Use the DbConnection
's GetSchema
method or the DataReader
'sGetSchemaTable
method.
Provided that you have a reader for the for the query, you can do something like this:
using(DbCommand cmd = ...) using(var reader = cmd.ExecuteReader()) { var schema = reader.GetSchemaTable(); foreach(DataRow row in schema.Rows) { Debug.WriteLine(row["ColumnName"] + " - " + row["DataTypeName"]) } }
See this article for further details.
回答2
In SQL Server, you can use this query:
USE Database_name SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Table_Name';
And do not forget to replace Database_name
and Table_name
with the exact names of your database and table names.
这篇关于How can I show the table structure in SQL Server query?的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-01-08Docker下的SqlServer发布订阅启用
- 2023-06-05Docker安装MS SQL Server并使用Navicat远程连接
- 2023-05-25深入浅出 SQL Server CDC 数据同步
- 2023-05-12通过空间占用和执行计划了解SQL Server的行存储索引
- 2023-04-24以SQLserver为例的Dapper详细讲解
- 2022-11-30SQL server高级函数查询
- 2022-11-26SQL SERVER数据库服务器CPU不能全部利用原因分析
- 2022-11-21SQL Server 时间算差值/常用函数
- 2022-11-20调试Archery连接SQL Server提示驱动错误
- 2022-10-22SQL Server 完整、差异备份+完整、差异还原(详细讲解,规避错误)