Get Column Information in A Table

最新推荐文章于 2021-04-07 19:34:34 发布
最新推荐文章于 2021-04-07 19:34:34 发布
阅读量215 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： SQL Daily Maintanence 文章标签： table insert sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/envykok/article/details/6094791
本文介绍如何在指定数据库中创建临时表用于存储表结构信息，并通过存储过程填充该临时表。接着展示了如何从临时表中筛选特定表及列的详细定义。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

<!-- /* Font Definitions */ @font-face {font-family:SimSun; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:宋体; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} @font-face {font-family:"/@SimSun"; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0cm; margin-right:0cm; margin-bottom:10.0pt; margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:SimSun; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:SimSun; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page WordSection1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} -->

Use [DBNAME]

GO

CREATE TABLE #temp

(

   TABLE_QUALIFIER VARCHAR ( 512),

   TABLE_OWNER VARCHAR ( 512),

   TABLE_NAME VARCHAR ( 512),

   COLUMN_NAME VARCHAR ( 512),

   DATA_TYPE VARCHAR ( 512),

   TYPE_NAME VARCHAR ( 512),

   PRECISION VARCHAR ( 512),

   LENGTH VARCHAR ( 512),

   SCALE VARCHAR ( 512),

   RADIX VARCHAR ( 512),

   NULLABLE VARCHAR ( 512),

   REMARKS VARCHAR ( 512),

   COLUMN_DEF VARCHAR ( 512),

   SQL_DATA_TYPE VARCHAR ( 512),

   SQL_DATETIME_SUB VARCHAR ( 512),

   CHAR_OCTET_LENGTH VARCHAR ( 512),

   ORDINAL_POSITION VARCHAR ( 512),

   IS_NULLABLE VARCHAR ( 512),

   SS_DATA_TYPE VARCHAR ( 512)

)

 

INSERT INTO #temp EXEC sp_columns 'tablename'

 

SELECT TABLE_NAME, COLUMN_NAME, TYPE_NAME , COLUMN_DEF, IS_NULLABLE

FROM #temp

WHERE TABLE_NAME= ' tablename '

        AND COLUMN_NAME= 'columnname'

 

DROP TABLE # temp

【MySQL】MySQL USE 库的时候报错 Reading table information for completion of table and column names
九师兄
07-01 1514
1.背景 mysql -A不预读数据库信息(use dbname 更快) —Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A mysql> use dbname Reading table information for completion of table and column names.
Reading table information for completion of table and column names 含义解释
zhang197093的博客
08-19 5621
当我们在命令行下使用 USE DBNAME 切换数据库时，有时会出现这个提示： Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed 这段话的意识是说，正在读取表信息用于表名和字段名的自动补全，你可以使用 -A 参数关闭这一特性。 也就是说在默认的情况下，你在输入sq
mysql切换table_mysql切换数据库提示：Reading table information for completion of table and column names的解决方法...
weixin_30350163的博客
01-25 1240
登录数据库后，选择数据库时发现以下提示，mysql> use testReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql>意思是 预读这个库...
解决：Reading table information for completion of table and column names
数据开发探索者
04-07 7504
mysql -A不预读数据库信息(use dbname 更快)—Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A https://img-blog.youkuaiyun.com/20160716004635662 mysql> use dbnameReading table information for
Reading table information for completion of table and column names
programercch的博客
06-09 1697
命令行操作数据库时发现这样的问题: mysql> use dbname  Reading table information for completion of table and column names  You can turn off this feature to get a quicker startup with -A  然后就卡在这里。 是由于数据库太大，即数据库
Select Column Name from a Table
我的博客
01-27 1770
Select Column Name from a Table We know with desc table_name we can see the different attribute of the table. Someone asked me how I can select column_name from a table. It can be done through query from various tables. DBA_TAB_COL_STATISTICSDBA_TAB
mysql切换数据库提示警告：Reading table information for completion of table and column names...
weixin_34391445的博客
08-30 2047
登录数据库后，选择数据库时发现以下提示， mysql> use testReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -A Database changedmysql> ...
使用MySQL数据库时出现“Reading table information for completion of table and column names...”
qq_40572277的博客
04-07 1847
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | | test_db_tw...
Reading table information for completion of table and column names You can turn off this feature to...
weixin_30745553的博客
07-14 1865
如下： mysql>use databasename Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A 造成的原因 ： 1.于MYSQL中数据...
get table info by column name
我的英文站点：https://iorilan.medium.com/
02-15 1267
in sql server .if you only know the column name but forget the table name(ussally in large systems ) , try this : SELECT COLUMN_NAME,*  FROM INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME = 'Task
Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
12-03
如果你不需要这个功能，可以使用-A选项关闭它，这样可以更快地启动。这个提示通常出现在使用MySQL命令行工具时。如果你想保留这个功能，可以忽略这个提示。 --相关问题--: 1. 如何在MySQL命令行工具中使用-A选项？ ...
How to get column name of qtable
最新发布
12-15
To get the column names of a table in Oracle, you can use the `ALL_TAB_COLUMNS` view or the `INFORMATION_SCHEMA.COLUMNS` view, assuming you have appropriate privileges. Here's an example using dynamic...
SQL Server - max worker threads (max user connections)
10-28 389
sp_configure 'show advanced options',1 ; GO RECONFIGURE; GO sp_configure 'max worker threads'http://technet.microsoft.com/en-us/library/ms187024.aspxhttp://loadrunnertnt.blogspot.com/2007/05/monitors-ms-sql-server.htmlUser Connections (SQLServer: G
Shrink Data File
12-16 317
http://technet.microsoft.com/en-us/library/ms189493.aspxRemarks DBCC SHRINKFILE applies to the files in the current database. For more information about how to change the current database, see USE (Transact-SQL) .DBCC SHRINKFILE operations can be stopp
Performance tuning - NO.1 process (in process)
07-27 288
(1) sp_spaceused 'tablename'(2)find out large readsDBCC DROPCLEANBUFFERS    DBCC FREEPROCCACHE SET STATISTICS IO ON    SET STATISTICS TIME ON(3) find out indexes spaceSELECT name,used,* FROM Sysindexes WHERE id=object_id('tablename')  ;(4) unused inde
Level 400 Performance tuning
11-28 270
PART 1 : sort in memory or sort split to tempdb, memory allocation SET STATISTICS TIME ON GO monitor activity SELECT num_of_reads, num_of_bytes_read,num_of_writes,num_of_bytess_written FROM sys.dm_io_virtual_file_stats(db_id('tempdb'),1) Memory pres
SQL Login 问题
04-29 265
 当用户使用*.bak去还原时候,database 可能带有user,但这个还没有注册到login里面,可以用: EXEC sp_change_users_login Auto_Fix,username 去自动更新Login http://www.seattletech.com/forum/viewtopic.php?t=71 After the use
bulk insert语句和bcp实用工具
06-02 255
bulk insert语句和bcp实用工具http://www.it118.org/specials/c9fba99e-4401-49cf-8256-ac3c1a34c0d9/8bf47df8-cad8-4d97-9a54-ba461a9c017a.htmbulk insert语句和bcp实用工具用于在SQL SERVER 数据库和数据文件之间复制数据.(ps:关于导入和导出数据的更多使用方法,可以参考《sql server联机丛书》的 “管理 SQL Server ”-->“导入和导出数据”章节)bulk
Code Format
09-28 254
SQLAlso consider some online SQL formatting tools:SQLInform's online SQL formatter - requires Java in your browser.SQLRefactor from Red Gate - ~$300Instant SQL Formatter online at dpriver.com Apparently they have a SQL Management Studio plugin for $5
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值