{"id":149,"date":"2011-08-25T13:24:54","date_gmt":"2011-08-25T07:54:54","guid":{"rendered":"https:\/\/blog.binarybits.net\/?p=149"},"modified":"2011-08-25T13:24:54","modified_gmt":"2011-08-25T07:54:54","slug":"get-list-of-all-table-along-with-their-column-name","status":"publish","type":"post","link":"https:\/\/blog.binarybits.net\/get-list-of-all-table-along-with-their-column-name\/","title":{"rendered":"Get list of all table name along with their column name"},"content":{"rendered":"
The following MS SQL query can be used to get list of tables along with their column details.<\/p>\n
SELECT *\u00a0FROM INFORMATION_SCHEMA.COLUMNS<\/p><\/blockquote>\n