sqlserver判断字段类型
时间: 2023-09-18 16:09:35 浏览: 82
要判断SQL Server中的字段类型,有几种方法可以使用。其中一种方法是使用以下代码查询整个数据库的表及其数据类型和说明:
```sql
SELECT object_name(ID) AS 表名, c.name AS 字段名, t.name AS 数据类型, c.length AS 长度, c.isnullable AS 是否可空, c.collation AS 字符排序规则, p.value AS 说明
FROM syscolumns c
JOIN systypes t ON c.xtype = t.xtype
LEFT JOIN sys.extended_properties p ON c.id = p.major_id AND c.colid = p.minor_id
WHERE objectproperty(c.id, 'IsUserTable') = 1
ORDER BY object_name(ID), c.colorder
```
这段代码将返回每个字段的表名、字段名、数据类型、长度、是否可空、字符排序规则和说明。注意,在查询之前,你需要将`<em>sql</em>`替换为实际的数据库名称。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [SQL 判断字段类型语句](https://download.csdn.net/download/weixin_38660918/13696627)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *2* [sql server查询字段数据类型、或者说是表结构](https://blog.csdn.net/h4568502h/article/details/115573195)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *3* [vb.net链接sqlserver数据库,加mdi父窗口背景按钮功能](https://download.csdn.net/download/Xiucai198702/88214354)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
[ .reference_list ]
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)