在sql server 2008中选择表详细信息 [英] Select table detail in sql server 2008
本文介绍了在sql server 2008中选择表详细信息的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
exec sp_help''tablename''
给出整表信息,但我只想要Column_name,数据类型和表长度
我怎样才能得到它?
解决方案
你好
检查这个...
SELECT ORDINAL_POSITION,Column_Name,
CASE WHEN Data_Type = ' 数字' THEN Data_type + ' (' + CONVERT( VARCHAR ,Numeric_Precision)+ ' ,' + CONVERT( VARCHAR ,Numeric_Scale)+ ' )'
WHEN Data_Type = ' Varchar' OR Data_Type = ' Char' 那么 Data_type + ' (' + CONVERT( VARCHAR ,Character_Maximum_Length)+ < span class =code-string>' )'
ELSE Data_type END ' 数据类型',
CASE WHEN IS_Nullable = ' < span class =code-string> NO' 那么 ' NN' ELSE ' N' END ' NUll / NOT NULL'
FROM Information_Schema.Columns
WHERE table_name = ' Table_Name'
ORDER BY TABLE_NAME,ORDINAL_POSITION
试试这个
SELECT column_name ' 列名',
data_type ' 数据类型',
character_maximum_length ' 最大长度'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = ' Country'
sp_help返回所有结果。
您始终可以将结果放在临时表中,然后只为您需要的项目编写视图。
>
exec sp_help ''tablename''
give whole table information but i want only Column_name ,datatype and Length of table
How can i get it ?
解决方案
Hi
Check this...
SELECT ORDINAL_POSITION , Column_Name, CASE WHEN Data_Type = 'Numeric' THEN Data_type + '('+CONVERT(VARCHAR,Numeric_Precision)+','+CONVERT(VARCHAR,Numeric_Scale) +')' WHEN Data_Type = 'Varchar' OR Data_Type = 'Char' THEN Data_type + '('+CONVERT(VARCHAR,Character_Maximum_Length)+')' ELSE Data_type END 'Data Type', CASE WHEN IS_Nullable = 'NO' THEN 'NN' ELSE 'N' END 'NUll/NOT NULL' FROM Information_Schema.Columns WHERE table_name = 'Table_Name' ORDER BY TABLE_NAME , ORDINAL_POSITION
Try This One
SELECT column_name 'Column Name', data_type 'Data Type', character_maximum_length 'Maximum Length' FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'Country'
sp_help returns all results.
You can always put the results in a temporary table and then write a view for only those items you require.
这篇关于在sql server 2008中选择表详细信息的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文