Pages

Men

rh

7/29/2014

How to get column name and data type of particular table in sql server

SELECT COLUMN_NAME 'All_Columns',DATA_TYPE  FROM

INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='TBL_Users'

O/P:-

No comments :

Post a Comment