sqlserver 2008r2 查看表结构及视图、版本及数据类型(字段)

太过爱你忘了你带给我的痛 2021-09-24 04:30 655阅读 0赞

一、查看表结构

sp_columns Student;

注：[https://blog.csdn.net/justdb/article/details/7435600][https_blog.csdn.net_justdb_article_details_7435600]

也可使用 sp\_help table\_name

注：[https://www.cnblogs.com/qianjinyan/p/6729760.html][https_www.cnblogs.com_qianjinyan_p_6729760.html]

二、查看视图(两种方式)

sp_helptext    v_student;

2.选择视图---右键----编写视图脚本为-----ALTER到----剪贴板 粘贴即可

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl_size_16_color_FFFFFF_t_70][]

注：[https://www.cnblogs.com/kekelele/p/11547228.html][https_www.cnblogs.com_kekelele_p_11547228.html]

三、查看sqlserver版本

SELECT @@VERSION

注：[https://blog.csdn.net/icecoola\_/article/details/79651666][https_blog.csdn.net_icecoola_article_details_79651666]

四、sqlserver中的数据类型

[http://www.maomao365.com/?p=5493][http_www.maomao365.com_p_5493]

[https_blog.csdn.net_justdb_article_details_7435600]: https://blog.csdn.net/justdb/article/details/7435600
[https_www.cnblogs.com_qianjinyan_p_6729760.html]: https://www.cnblogs.com/qianjinyan/p/6729760.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl_size_16_color_FFFFFF_t_70]: /images/20210923/73661171558b40d7bbb6fa9053234e8a.png
[https_www.cnblogs.com_kekelele_p_11547228.html]: https://www.cnblogs.com/kekelele/p/11547228.html
[https_blog.csdn.net_icecoola_article_details_79651666]: https://blog.csdn.net/icecoola_/article/details/79651666
[http_www.maomao365.com_p_5493]: http://www.maomao365.com/?p=5493