像BigQuery这样的现代SQL方言提出了一个极好的解决方案。

SELECT * EXCEPT(ColumnNameX, [ColumnNameY, ...])
FROM TableA

这是一种非常强大的SQL语法，可以避免由于表列名更改而需要随时更新一长串列。而这个功能在当前的SQL Server实现中是缺失的，这是一个遗憾。希望有一天，微软Azure对数据科学家更加友好。

数据科学家喜欢有一个快速选项来缩短查询并删除一些列(由于重复或任何其他原因)。

https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select-modifiers

您可以使用REGEX列规范。

下面的查询选择除ds和hr之外的所有列 选择(ds |人力资源)? +。+来自销售

不，这是不可能的。如果在您的情况下可行，也许您可以创建自定义视图

如果你的数据库支持动态sql的执行，你可以写一个SP，把你不想看到的列传递给它，让它动态创建查询并返回结果给你。我认为这至少在SQL Server中是可行的

你可以创建一个包含你想要选择的列的视图，然后你可以从视图中选择*…

是的，这是可能的(但不建议)。

CREATE TABLE contact (contactid int, name varchar(100), dob datetime)
INSERT INTO contact SELECT 1, 'Joe', '1974-01-01'

DECLARE @columns varchar(8000)

SELECT @columns = ISNULL(@columns + ', ','') + QUOTENAME(column_name)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'contact' AND COLUMN_NAME <> 'dob'
ORDER BY ORDINAL_POSITION

EXEC ('SELECT ' + @columns + ' FROM contact')

代码说明:

Declare a variable to store a comma separated list of column names. This defaults to NULL. Use a system view to determine the names of the columns in our table. Use SELECT @variable = @variable + ... FROM to concatenate the column names. This type of SELECT does not not return a result set. This is perhaps undocumented behaviour but works in every version of SQL Server. As an alternative you could use SET @variable = (SELECT ... FOR XML PATH('')) to concatenate strings. Use the ISNULL function to prepend a comma only if this is not the first column name. Use the QUOTENAME function to support spaces and punctuation in column names. Use the WHERE clause to hide columns we don't want to see. Use EXEC (@variable), also known as dynamic SQL, to resolve the column names at runtime. This is needed because we don't know the column names at compile time.

实际上雪花刚刚发布了排除，所以现在你只需要

SELECT *排除[columnA,columnB，…][英语背诵文选