每日一贴,今天的内容关键字为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和查询
---------------------------------