Find total Number of columns in a Table in SQL Database - Tamil Codes

Find total Number of columns in a Table in SQL Database

SQL July 21, 2018 , by admin Comments Off

SQL Query to find total number of columns in a Table in SQL Database,

SELECT COUNT(*)
  FROM INFORMATION_SCHEMA.COLUMNS
 WHERE table_catalog = 'DatabaseName' -- the database
   AND table_name = 'TableName'

Author

admin