SQL statements in SQL Server that use T-SQL commands to query which tables in a database _mssql

1. Query all tables in sql:

Select table_name from database name. Information_schema. Tables Where table_type= ' BASE table ' is executed, you can see the names of all the tables in the database that belong to you

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.sysobject s on dbo.syscolumns.id = Dbo.sysobjects.id Where (dbo.sysobjects.xtype = ' u ') and ("not" (Dbo.sysobjects.name like ' Dtproper Ties '))

3, in the SQL Query Analyzer, there is also a simple query method:

EXEC sp_msforeachtable @command1 = "sp_spaceused '" after execution, you can see information about all the user tables in the database

4, query total number of stored procedures:

Select COUNT (*) Total stored procedure number from sysobjects where xtype= ' P '

D = defaults or DEFAULT constraint
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