How do I get ONLY data type and name of all the columns available in given table_name
tonyaim83
-2
Light Poster
Recommended Answers
Jump to Posthere is a couple more columns than you need, just so you can be clear on the query
SELECT sysobjects.name AS "TABLE_NAME", syscolumns.name AS "COLUMN_NAME", systypes.name AS "DATA_TYPE", syscolumns.LENGTH AS "LENGTH" FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id INNER JOIN systypes ON syscolumns.xtype = systypes.xtype …
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.