Anil Singh | Code-sample.com

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'