Thursday, April 2, 2009

SQL Query that search all column names based on criteria

Search All Column that names like (at..)

select * from INFORMATION_SCHEMA.COLUMNS where
"COLUMN_NAME" LIKE '%at%';

No comments:

Post a Comment

 
span.fullpost {display:inline;}