SQL SERVER TOTAL ROWS / COLUMN COUNT

GET TOTAL ROWS COUNT OF A TABLE

SELECT COUNT(*) as TOTAL_TBL_ROWS FROM [ORDER]

GET TOTAL COLUMNS COUNT OF TABLE

SELECT COUNT(*) as TOTAL_TBL_COLUMNS FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME= 'ORDER'

OR

SELECT COUNT(*) AS TOTAL_TBL_COLUMNS FROM INFORMATION_SCHEMA.COLUMNS

       WHERE TABLE_CATALOG = 'MDM'

            AND TABLE_SCHEMA = 'dbo'

            AND TABLE_NAME = 'ORDER'