Check the data tables in the database on SQL Server

You can obtain the desired data table information from the system table sysobjects in the database. The specific SQL statement is as follows:

Select name from sysobjects where type = 'U ';

Because the system table sysobjects stores all database objects, type indicates the types of various objects, including:
U = User table
S = system table
C = check Constraints
D = default value or default Constraint
F = foreign key constraint
L = Log
Fn = scalar function
If = embedded table functions
P = Stored Procedure
PK = primary key constraint (type: K)
Rf = copy and filter the Stored Procedure
TF = table functions
Tr = trigger
Uq = unique constraint (type is K)
V = View
X = Extended Stored Procedures and Related Object Information.

PS: Open the database

Use sales
Go

You can obtain the desired data table information from the system table sysobjects in the database. The specific SQL statement is as follows:

Select name from sysobjects where type = 'U ';

Because the system table sysobjects stores all database objects, type indicates the types of various objects, including:
U = User table
S = system table
C = check Constraints
D = default value or default Constraint
F = foreign key constraint
L = Log
Fn = scalar function
If = embedded table functions
P = Stored Procedure
PK = primary key constraint (type: K)
Rf = copy and filter the Stored Procedure
TF = table functions
Tr = trigger
Uq = unique constraint (type is K)
V = View
X = Extended Stored Procedures and Related Object Information.

PS: Open the database

Use sales
Go