Member Avatar for Saikumar Adep

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

  • 2 Contributors
  • 3 Replies
  • 138 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

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.

Member Avatar for Saikumar Adep

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

Member Avatar for debasisdas

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.

Edited by debasisdas because: n/a
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.