TABLE SCHEMA GET COLUMN NAME FROM TABLE

SELECT COLUMN_NAME FROM INFORMATION_sCHEMA.COLUMNS WHERE TABLE_NAME='TABLENAME'


or

select * from sys.columns where object_id in(select object_id from sys.tables where name='tablename')