Select query without identy column

Question

i want Select query without identy column.. can select data without identity column data?

Suthish Nair · Answer

another duplicate

John Penn · Answer

Yes. You can create a select query that specifies the columns you want: SELECT FirstName LastName FROM Person If Person has an identity column you won't see it in the resultset.