How to get COLUMN COUNT in SQL

This video is about how to get COLUMN COUNT in SQL.

Script:
SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'persons'

Keywords:
how to get COLUMN count in SQL,column count sql,column count in sql,sql column count,count of columns in sql,get column count sql,get column count in sql,get sql column count,count of columns in table sql,sql count of column table,count of column in table,sql count of column in table, sql column count, sql column count query, sql column count, sql column count query, column count sql, column count sql, column count in sql, column count sql query, columns count sql, column count sql query, field count sql, sql server, learn sql, sql

[alagandulasandeep]

there is no column name like table_name ....how your get out put (where table_name='person')

[Aleamgd]

ال ai ماقدر يحلها للاسف. شكرا لان ناشره هاذا الفيديو الخفيف

[deepakpatel]

Query is wrong, there is no table with the name of columns