如何在单行中获取表格详细信息？ [英] how to get table details in single row ?

问题描述

任何人都可以帮我查询单行获取表名，列名，列数据类型，isprimary等。



例如：

我的员工表的输出列E_Id，E_Name，E_City应该如下



---- -------------------------------------------------- --------------------------------------------

TabName ColumnName数据类型isprimary Columnname数据类型isprimary Columnname数据类型iprimary



员工 - E_Id - int - S - E_Name - varchar - N - E_City - varchar - N




----------------------------- -------------------------------------------------- -------------------

Hi ,
Can anyone help me with the query to get table name,column name , column datatype , isprimary etc in single row .

for eg:
My output of employee table with Columns E_Id,E_Name,E_City should be as below

--------------------------------------------------------------------------------------------------
TabName ColumnName datatype isprimary Columnname datatype isprimary Columnname datatype iprimary

Employee - E_Id - int - S - E_Name - varchar - N - E_City - varchar - N


--------------------------------------------------------------------------------------------------

推荐答案

看一下这个帖子接受的答案;）

http://stackoverflow.com/questions/10784369/to-get-table-details < /一个> [ ^ ]

Take a look at this thread's accepted answer ;)
http://stackoverflow.com/questions/10784369/to-get-table-details[^]

chage你的表名和列名

chage your table name and column name

select t1.user_id,t1.DATA_TYPE,t1.IS_NULLABLE,t2.name,t2.DATA_TYPE,t2.IS_NULLABLE,t3.city,t3.DATA_TYPE,t3.IS_NULLABLE from
(select  a.user_id ,b.DATA_TYPE,b.IS_NULLABLE from  tbl_user_registration as a left join INFORMATION_SCHEMA.COLUMNS as b  on  b.TABLE_NAME='tbl_user_registration' and b.COLUMN_NAME='user_id')as t1,

(select  a.user_id,a.name ,b.DATA_TYPE,b.IS_NULLABLE from  tbl_user_registration as a left join INFORMATION_SCHEMA.COLUMNS as b  on  b.TABLE_NAME='tbl_user_registration' and b.COLUMN_NAME='name') as t2,

(select a.user_id, a.city ,b.DATA_TYPE,b.IS_NULLABLE from  tbl_user_registration as a left join INFORMATION_SCHEMA.COLUMNS as b  on  b.TABLE_NAME='tbl_user_registration' and b.COLUMN_NAME='city') as t3  where t1.user_id=t2.user_id and t1.user_id=t3.user_id

你可能会得到想法

you may get ideas

这篇关于如何在单行中获取表格详细信息？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！