Friday, January 19, 2018

How to Find columns Name from Table



select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS 
where TABLE_NAME='tblName'

Find Column Count from Table
select max_column_id_used from sys.tables where name like '%tblName%'

No comments:

Post a Comment

javascript Filter/index off

 var family = [{"name":"Jack",  "age": 26},               {"name":"Jill",  "age"...