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