<div>
I noticed when I ran SELECT * FROM syscolumns, the affected rows 11223, but when I ran SELECT Count(*) FROM syscolumns, it returned 10757. &nbsp;Are the remaining 466 the lines of instruction of Stored Procedures?
</div>


I noticed when I ran SELECT * FROM syscolumns, the affected rows 11223, but when I ran SELECT Count(*) FROM syscolumns, it returned 10757.  Are the remaining 466 the lines of instruction of Stored Procedures?

<div>
<div class="content wysiwyg-content">
I can see all the contents of syscolumns, but how do I query for a row count of syscolumns?<br />
<br />
Thanks!<br />
JohnD
</div>
</div>


I can see all the contents of syscolumns, but how do I query for a row count of syscolumns?

Thanks!
JohnD

SELECT * FROM syscolumns

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.