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;
No comments:
Post a Comment