Please visit DEMANDDRAFT.SHOP for quality of products...

Ad

Search This Blog

Tuesday, July 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