Thursday, September 1, 2011

Find column from T-SQL...

SELECT TABLE_NAME
ORDINAL_POSITION
,COLUMN_NAME
,DATA_TYPE
,CHARACTER_MAXIMUM_LENGTH
,IS_NULLABLE
,COLUMN_DEFAULT,*
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
COLUMN_NAME like '%patientrespons%'
ORDER BY
ORDINAL_POSITION ASC;
#trivedimehulk@gmail.com

No comments:

Post a Comment