Monday, June 16, 2014

FIND THE TABLE WHICH HAS MAX COLUMNS IN A DATABASE

How to find the Table which has Maximum Columns in a database


SELECT NAME AS Table_Name, max_column_id_used AS Total_Columns
From SYS.tables
WHERE max_column_id_used =
(SELECT MAX(max_column_id_used) FROM SYS.tables)

No comments:

Post a Comment