如何从 SQL Server 的表中获取列名？

我想查询一个表的所有列的名称。我发现如何做到这一点：

• Oracle https://stackoverflow.com/q/452464/419956
• MySQL https://stackoverflow.com/q/193780/419956
• PostgreSQL https://dba.stackexchange.com/q/22362/5089

但我还需要知道：这怎么能在微软SQL服务器（我的情况是 2008 年）？

您可以通过查询来获取此信息以及更多信息信息架构视图 http://msdn.microsoft.com/en-us/library/aa933204%28SQL.80%29.aspx.

此示例查询：

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Customers'

可以对所有这些数据库对象进行创建：

• 检查约束 https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/check-constraints-transact-sql
• COLUMN_DOMAIN_USAGE https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/column-domain-usage-transact-sql
• COLUMN_PRIVILEGES https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/column-privileges-transact-sql
• COLUMNS https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/columns-transact-sql
• CONSTRAINT_COLUMN_USAGE https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/constraint-column-usage-transact-sql
• CONSTRAINT_TABLE_USAGE https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/constraint-table-usage-transact-sql
• DOMAIN_CONSTRAINTS https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/domain-constraints-transact-sql
• DOMAINS https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/domains-transact-sql
• KEY_COLUMN_USAGE https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/key-column-usage-transact-sql
• 参数 https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/parameters-transact-sql
• REFERENTIAL_CONSTRAINTS 参考约束 https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/referential-constraints-transact-sql
• ROUTINES https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/routines-transact-sql
• 例程_列 https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/routine-columns-transact-sql
• SCHEMATA https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/schemata-transact-sql
• 表约束 https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/table-constraints-transact-sql
• TABLE_PRIVILEGES https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/table-privileges-transact-sql
• TABLES https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/tables-transact-sql
• VIEW_COLUMN_USAGE https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/view-column-usage-transact-sql
• VIEW_TABLE_USAGE https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/view-table-usage-transact-sql
• VIEWS https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/views-transact-sql