How many tables are in SQL Server query database

How many tables are in SQL Server query database <div class= "Articaltitle" style= "Clear:both; line-height:20px; Padding-bottom:10px;>

SELECT * from sysobjects WHERE (xtype = ' U ')

C = CHECK constraint
D = defaults or Default constraints
F = FOREIGN KEY constraint
L = Log
FN = Scalar function
IF = inline table function
P = stored procedure
PK = PRIMARY KEY constraint (type is K)
RF = copy Filter stored procedure
S = system table
TF = table function
TR = Trigger
U = User table
UQ = UNIQUE constraint (type is K)
V = View
X = extended stored Procedure

To view the table structure:

Use DatabaseName;

sp_help ' table name '; Note that you want to use quotation marks

How many tables are in SQL Server query database