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

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.

您可以从devart.com获得SQL Complete，它不仅像Red Gate的SQL Prompt一样展开*通配符(如cairnz的回答所述)，而且还提供了一个列选择器下拉复选框，您可以在选择列表中选中您想要的所有列，它们将自动为您插入(如果您然后取消选中某个列，它将自动从选择列表中删除)。

在SQL Management Studio中，您可以展开对象资源管理器中的列，然后将columns树项拖到查询窗口中，以获得以逗号分隔的列列表。

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

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

如果你正在使用mysql-workbench，你可以右键单击表资源管理器，然后单击“发送到SQL编辑器->选择所有语句”。

它会发送一条语句，比如“Select col1, col2，…”从表”。

然后删除那些你不需要的。

如果我们谈论的是过程，它使用这个技巧来生成一个新的查询并立即执行它:

SELECT LISTAGG((column_name), ', ') WITHIN GROUP (ORDER BY column_id)
INTO var_list_of_columns
FROM ALL_TAB_COLUMNS
WHERE table_name = 'PUT_HERE_YOUR_TABLE'
AND column_name NOT IN ('dont_want_this_column','neither_this_one','etc_column');