SQL statements in SQL Server that use T-SQL commands to query which tables in a database _mssql
Source: Internet
Author: User
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
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.