SQL Server uses T-SQL commands to query which tables in a database SQL statements

1. query all tables in SQL:

Select TABLE_NAME FROM database name. INFORMATION_SCHEMA.TABLES Where TABLE_TYPE = 'base table' after execution, you can see the names of all tables created by yourself in the database.

2. query all tables and columns in SQL:

Select dbo. sysobjects. name as Table_name, dbo. syscolumns. name AS Column_name FROM dbo. syscolumns inner join dbo. sysobjects ON dbo. syscolumns. id = dbo. sysobjects. id Where (dbo. sysobjects. xtype = 'U') AND (NOT (dbo. sysobjects. name LIKE 'dtproperties '))

3. There is also a simple query method in the SQL query Analyzer:

EXEC sp_MSforeachtable @ command1 = "sp_spaceused '? '"After execution, you can see information about all user tables in the database.

4. query the total number of stored procedures:

Select count (*) Total number of stored procedures from sysobjects where xtype = 'P'

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
S = system table
TF = table functions
TR = trigger
U = User table
UQ = UNIQUE constraint (type is K)
V = View
X = Extended Stored Procedure