Is there a way to exclude column from a table or View or Stored Procedure without specifying all the columns in the Select List

Especially with table or View

Recommended Answers

All 3 Replies

No, if you do not want all the columns you need to specify the list of columns.

If it a table or a view you can create a view on the source object using only the desired columns.

There is no other alternative to this Query
Is there any select Query without specifying all columns

No.

You can use select * --- for select all the columns.

If you want selected list of columns only, you need to mention the list in your SQL.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.