Field in the tables in the server

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90350 More actions · Answer 1

You can use the information schema views or the system table sys.columns.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 2

select * from sys.columns

where name=''

go

select * from information_schema.columns

where column_name=''

MJ