-- View table attributes
Select * From sysobjects where [name] = 'core'
-- Usage
If exists (select * From sysobjects where [name] = 'region' and xtype = 'U ')
Drop table Table1
Go
Create Table1 ()
-- Get all user tables
Select name from sysobjects where xtype = 'U' and status> = 0
-- View table fields
Select * From syscolumns c Where C. ID = object_id ('region ')
Select name from syscolumns where id = object_id ('table name ')
-- View users
Select * From sysusers where status <> 0
-- View who has referenced the bbs_hits table (including views, stored procedures, and functions)
Select distinct object_name (D. id) as 'project ',
O. xtype
From sysdepends D inner join sysobjects o on D. id = O. ID
Where object_name (depid) = 'bbs _ hits'
-- View views, stored procedures, and functions related to a table
Select a. * From sysobjects A, syscomments B where a. ID = B. ID and B. Text like '% table name %'
-- View all stored procedures in the current database
Select name as stored procedure name from sysobjects where xtype = 'P'
-- Query the fields and Data Types of a table
Select column_name, data_type from information_schema.columns
Where table_name = 'table name'
[N]. [title]:
Select * From tablename order by customername
Specifically, xtype corresponds:
C = check Constraints
D = default value or default Constraint
F = foreign key constraint
Fn = scalar function
If = embedded table functions
K = primary key or unique constraint
L = Log
P = Stored Procedure
R = rule
Rf = copy and filter the Stored Procedure
S = system table
TF = table functions
Tr = trigger
U = User table
V = View
X = Extended Stored Procedure