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'