metadata查询Querying Metadata

每日一贴,今天的内容关键字为metadata查询

常用的元数据信息查询语句，记录下来，在某个时候还是很有效的。

--查询架构信息，SCHEMA_NAME这个方法重要用来将架构编号转换为架构名称

SELECT SCHEMA_NAME(schema_id) AS table_schema_name, name AS table_name
FROM sys.tables;

output:

table_schema_name  table_name
------------------ -------------
HR                 Employees
Production         Suppliers
Production         Categories
Production         Products
Sales              Customers
Sales              Shippers
Sales              Orders
Sales              OrderDetails

--查询表信息，TYPE_NAME这个方法，重要用来将类型编号转换为类型名称

SELECT
  name AS column_name,
  TYPE_NAME(system_type_id) AS column_type,
  max_length,
  collation_name,
  is_nullable
FROM sys.columns
WHERE object_id = OBJECT_ID(N'Sales.Orders');

output:

每日一道理
坚持的昨天叫立足，坚持的今天叫进取，坚持的明天叫成功。

column_name     column_type     max_length collation_name            is_nullable
--------------- --------------- ---------- ------------------------- -----------
orderid         int             4          NULL                      0
custid          int             4          NULL                      0
empid           int             4          NULL                      0
orderdate       datetime        8          NULL                      0
requireddate    datetime        8          NULL                      0
shippeddate     datetime        8          NULL                      1
shipperid       int             4          NULL                      0
freight         money           8          NULL                      0
shipname        nvarchar        80         Latin1_General_CI_AI      0
shipaddress     nvarchar        120        Latin1_General_CI_AI      0
shipcity        nvarchar        30         Latin1_General_CI_AI      0
shipregion      nvarchar        30         Latin1_General_CI_AI      1
shippostalcode  nvarchar        20         Latin1_General_CI_AI      1
shipcountry     nvarchar        30         Latin1_General_CI_AI      0

文章结束给大家分享下程序员的一些笑话语录：一位程序员去海边游泳，由于水性不佳，游不回岸了，于是他挥着手臂，大声求.救：“F1，F1！”

--------------------------------- 原创文章 By
metadata和查询
---------------------------------