SQL Server series: SQL statements query tables, views, stored procedures, and so on in the database

1. View the user table

Select  from Sys.tables

Select  from where type='U'

Select  from where xtype='U'

where type or xtype value:U = user table S = system table V = view FN = scalar function TF = table function P = stored procedure TR = Trigger

　　D = defaults or Default constraints PK = PRIMARY KEY constraint F = FOREIGN KEY constraint UQ = UNIQUE constraint

SELECT  from Information_schema. TABLES

2. View View

SELECT *  from Information_schema. Views

3. View the table/view fields

SELECT *  from WHERE = ' Product '

-- View Vproduct SELECT *  from WHERE = ' vproduct '

Select  from where = object_id ('Product')

SELECT  from WHERE  'Product'

SQL Server series: SQL statements query tables, views, stored procedures, and so on in the database