[MS-SQL] 테이블명, 컬럼명 검색

MS SQL을 이용한 응용프록램 개발시 버젼 업그레이드 등으로 사용되어질 테이블이 존재 하는 지 또는 조회 할 필드가 존재 하는지 확인해야 하는 경우가 있다. 그럴 경우 다음과 같이 처리하면 된다.
 테이블명 검색
SELECT * FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_NAME = ‘테이블명’
컬럼명 검색
SELECT * FROM information_schema.COLUMNS WHERE COLUMN_NAME = ‘컬럼명’
PK 검색
SELECT * FROM information_schema.KEY_COLUMN_USAGE

“[MS-SQL] 테이블명, 컬럼명 검색”의 261개의 댓글

  1. Aw, this was an incredibly nice post. Taking
    the time and actual effort to generate a great article… but what can I say…
    I hesitate a lot and never manage to get nearly anything done.

  2. I think this is among the most important information for me.
    And i am glad reading your article. But wanna remark on few general things, The website
    style is ideal, the articles is really nice : D.
    Good job, cheers

  3. I simply want to tell you that I am all new to weblog and actually liked you’re blog site. Almost certainly I’m going to bookmark your blog . You really have tremendous article content. With thanks for sharing your blog.

  4. Oh my goodness! a fantastic article dude. Thanks However I am experiencing issue with ur rss. Don?t recognize why Unable to register for it. Exists any person getting similar rss issue? Anybody that knows kindly respond. Thnkx

  5. I know this if off topic but I’m looking into starting my own blog and was wondering what all is needed to get setup? I’m assuming having a blog like yours would cost a pretty penny? I’m not very web smart so I’m not 100 sure. Any recommendations or advice would be greatly appreciated. Appreciate it

  6. Hi I am so grateful I found your web site, I really found you by accident, while I was looking on Yahoo for something else, Nonetheless I am here now and would just like to say many thanks for a remarkable post and a all round thrilling blog (I also love the theme/design), I don’t have time to look over it all at the minute but I have bookmarked it and also included your RSS feeds, so when I have time I will be back to read much more, Please do keep up the superb work.

  7. When I initially commented I clicked the -Notify me when new comments are added- checkbox as well as now each time a remark is included I obtain 4 emails with the same remark. Exists any way you can eliminate me from that service? Thanks!

  8. I uncovered your blog website on google as well as examine a few of your early articles. Continue to keep up the very good operate. I simply extra up your RSS feed to my MSN News Viewers. Seeking ahead to learning more from you later!?

  9. I?m amazed, I need to claim. Truly seldom do I come across a blog site that?s both instructional and also enjoyable, as well as let me inform you, you have actually struck the nail on the head. Your concept is exceptional; the concern is something that inadequate individuals are talking wisely around. I am extremely happy that I stumbled across this in my search for something connecting to this.

  10. Oh my goodness! Incredible article dude! Thanks, However I am having issues with your RSS. I don’t understand the reason why I am unable to subscribe to it. Is there anyone else getting similar RSS problems? Anyone that knows the answer will you kindly respond? Thanx!!

  11. Can I just say what a comfort to discover a person that truly knows what they’re discussing over the internet. You actually realize how to bring an issue to light and make it important. A lot more people must look at this and understand this side of the story. I was surprised that you are not more popular given that you surely possess the gift.

  12. Howdy! This article couldn’t be written much better! Looking at this article reminds me of my previous roommate! He continually kept preaching about this. I will forward this article to him. Pretty sure he’s going to have a good read. I appreciate you for sharing!

  13. When I originally commented I clicked the -Inform me when brand-new remarks are added- checkbox and currently each time a remark is included I obtain four e-mails with the very same remark. Exists any way you can eliminate me from that solution? Thanks!

  14. After looking over a handful of the articles on your blog, I honestly appreciate your way of blogging. I saved as a favorite it to my bookmark site list and will be checking back soon. Please check out my website too and tell me what you think.

  15. Hi there! This article could not be written much better! Looking through this post reminds me of my previous roommate! He constantly kept preaching about this. I most certainly will send this article to him. Pretty sure he’s going to have a great read. I appreciate you for sharing!

  16. Hi, I do think this is a great website. I stumbledupon it 😉 I’m going to come back once again since i have bookmarked it. Money and freedom is the greatest way to change, may you be rich and continue to help other people.

  17. After looking at a few of the blog articles on your web site, I honestly like your way of blogging. I book marked it to my bookmark site list and will be checking back in the near future. Please visit my web site too and let me know how you feel.

  18. This is the right web site for everyone who hopes to understand this topic. You understand a whole lot its almost hard to argue with you (not that I personally would want to…HaHa). You definitely put a brand new spin on a subject which has been written about for a long time. Wonderful stuff, just great!

  19. Howdy, I do believe your site may be having browser compatibility problems. Whenever I take a look at your website in Safari, it looks fine however, if opening in I.E., it has some overlapping issues. I just wanted to give you a quick heads up! Besides that, excellent site!

  20. An impressive share! I have just forwarded this onto a friend who has been conducting a little homework on this. And he actually ordered me lunch simply because I stumbled upon it for him… lol. So allow me to reword this…. Thank YOU for the meal!! But yeah, thanks for spending time to discuss this matter here on your blog.

  21. May I simply just say what a relief to find somebody that actually understands what they are talking about on the internet. You actually know how to bring an issue to light and make it important. More and more people have to look at this and understand this side of your story. I was surprised you’re not more popular given that you surely possess the gift.

  22. Hi, I do think this is a great site. I stumbledupon it 😉 I will return once again since I saved as a favorite it. Money and freedom is the best way to change, may you be rich and continue to help others.

  23. I’m amazed, I have to admit. Seldom do I encounter a blog that’s both equally educative and engaging, and without a doubt, you have hit the nail on the head. The problem is something which too few men and women are speaking intelligently about. Now i’m very happy I found this during my search for something regarding this.

  24. Hi, I do think your site might be having browser compatibility problems. When I look at your web site in Safari, it looks fine however when opening in Internet Explorer, it’s got some overlapping issues. I just wanted to give you a quick heads up! Apart from that, fantastic blog!

  25. After checking out a few of the blog posts on your blog, I truly like your technique of writing a blog. I book marked it to my bookmark site list and will be checking back soon. Please visit my web site as well and tell me your opinion.

  26. Howdy! I could have sworn I’ve been to this web site before but after going through a few of the posts I realized it’s new to me. Anyhow, I’m certainly pleased I stumbled upon it and I’ll be bookmarking it and checking back often!

  27. Having read this I thought it was very informative. I appreciate you finding the time and energy to put this information together. I once again find myself personally spending a lot of time both reading and posting comments. But so what, it was still worth it!

  28. You’re so interesting! I don’t believe I’ve read through a single thing like this before. So great to discover another person with unique thoughts on this topic. Really.. many thanks for starting this up. This web site is one thing that is needed on the internet, someone with a little originality!

  29. Aw, this was a very good post. Taking the time and actual effort to make a very good article… but what can I say… I put things off a lot and never manage to get anything done.

  30. I truly love your website.. Great colors & theme. Did you make this web site yourself? Please reply back as I’m planning to create my very own website and would love to know where you got this from or just what the theme is called. Many thanks!

  31. A motivating discussion is worth comment. I do think that you should publish more about this subject, it might not be a taboo subject but typically people don’t talk about such topics. To the next! Best wishes!!

  32. I’m very pleased to uncover this web site. I want to to thank you for your time for this fantastic read!! I definitely really liked every bit of it and I have you book marked to check out new information on your website.

  33. I absolutely love your website.. Pleasant colors & theme. Did you create this website yourself? Please reply back as I’m trying to create my very own website and would love to find out where you got this from or exactly what the theme is named. Thank you!

  34. You’re so awesome! I don’t think I’ve truly read through anything like that before. So wonderful to find another person with original thoughts on this topic. Seriously.. thank you for starting this up. This website is something that’s needed on the web, someone with a bit of originality!

  35. This is the right website for anybody who really wants to find out about this topic. You understand so much its almost tough to argue with you (not that I really would want to…HaHa). You certainly put a new spin on a subject which has been discussed for a long time. Great stuff, just wonderful!

  36. Right here is the right blog for everyone who would like to understand this topic. You know a whole lot its almost tough to argue with you (not that I actually would want to…HaHa). You definitely put a brand new spin on a topic that’s been discussed for ages. Great stuff, just great!

  37. I’m very happy to discover this website. I wanted to thank you for ones time for this fantastic read!! I definitely really liked every little bit of it and i also have you book marked to look at new stuff in your website.

  38. Oh my goodness! Amazing article dude! Many thanks, However I am encountering problems with your RSS. I don’t know the reason why I can’t join it. Is there anybody getting similar RSS issues? Anyone that knows the solution can you kindly respond? Thanks!!

  39. Oh my goodness! Incredible article dude! Thank you so much, However I am experiencing difficulties with your RSS. I don’t know the reason why I can’t subscribe to it. Is there anybody getting identical RSS problems? Anyone that knows the solution will you kindly respond? Thanks!!

  40. Next time I read a blog, I hope that it won’t disappoint me just as much as this one. I mean, Yes, it was my choice to read through, but I actually thought you would have something helpful to talk about. All I hear is a bunch of whining about something that you could possibly fix if you were not too busy looking for attention.

  41. I’m impressed, I must say. Rarely do I encounter a blog that’s both educative and interesting, and let me tell you, you’ve hit the nail on the head. The issue is something that not enough men and women are speaking intelligently about. Now i’m very happy I stumbled across this during my hunt for something regarding this.

  42. Right here is the perfect website for everyone who wants to find out about this topic. You understand a whole lot its almost hard to argue with you (not that I personally will need to…HaHa). You definitely put a brand new spin on a topic that’s been discussed for many years. Excellent stuff, just excellent!

  43. Nice post. I learn something new and challenging on sites I stumbleupon on a daily basis. It will always be exciting to read articles from other authors and practice a little something from other websites.

  44. I blog quite often and I truly appreciate your information. This article has truly peaked my interest. I’m going to bookmark your blog and keep checking for new information about once per week. I subscribed to your Feed as well.

  45. Right here is the perfect webpage for anyone who hopes to find out about this topic. You realize a whole lot its almost tough to argue with you (not that I really will need to…HaHa). You certainly put a fresh spin on a subject that has been written about for decades. Wonderful stuff, just wonderful!

  46. Everything is very open with a really clear explanation of the challenges. It was definitely informative. Your website is extremely helpful. Thanks for sharing!

  47. Good post. I learn something totally new and challenging on blogs I stumbleupon every day. It will always be helpful to read through content from other authors and practice something from other web sites.

  48. I’d like to thank you for the efforts you have put in penning this blog. I’m hoping to check out the same high-grade blog posts from you in the future as well. In truth, your creative writing abilities has encouraged me to get my own site now 😉

  49. An intriguing discussion is worth comment. I think that you ought to write more about this issue, it may not be a taboo matter but generally people don’t talk about such subjects. To the next! Many thanks!!

  50. You are so awesome! I do not think I’ve read through a single thing like this before. So great to find another person with a few genuine thoughts on this subject. Seriously.. thank you for starting this up. This website is something that is required on the web, someone with some originality!

  51. Good post. I learn something totally new and challenging on websites I stumbleupon on a daily basis. It will always be interesting to read through content from other authors and use a little something from their web sites.

  52. I’d like to thank you for the efforts you’ve put in penning this site. I really hope to check out the same high-grade blog posts by you later on as well. In truth, your creative writing abilities has inspired me to get my very own site now 😉

  53. An outstanding share! I’ve just forwarded this onto a co-worker who had been conducting a little research on this. And he actually ordered me lunch because I found it for him… lol. So allow me to reword this…. Thanks for the meal!! But yeah, thanks for spending the time to talk about this topic here on your internet site.

  54. I’m impressed, I must say. Seldom do I come across a blog that’s both equally educative and engaging, and let me tell you, you’ve hit the nail on the head. The issue is an issue that not enough folks are speaking intelligently about. Now i’m very happy I found this in my search for something relating to this.

  55. I’m very happy to uncover this site. I want to to thank you for ones time just for this fantastic read!! I definitely enjoyed every part of it and i also have you saved to fav to see new things on your web site.

  56. You are so cool! I don’t suppose I’ve read through anything like this before. So good to discover someone with genuine thoughts on this issue. Really.. thank you for starting this up. This website is one thing that is needed on the internet, someone with a little originality!

  57. Can I simply say what a comfort to uncover somebody who genuinely knows what they are talking about on the internet. You actually understand how to bring an issue to light and make it important. A lot more people must read this and understand this side of the story. I was surprised you are not more popular since you definitely possess the gift.

  58. I was excited to uncover this site. I need to to thank you for your time for this wonderful read!! I definitely loved every bit of it and I have you bookmarked to check out new information on your site.

  59. Your style is so unique compared to other people I have read stuff from. Many thanks for posting when you have the opportunity, Guess I will just book mark this blog.

  60. I seriously love your website.. Great colors & theme. Did you develop this amazing site yourself? Please reply back as I’m hoping to create my own personal site and would love to know where you got this from or what the theme is called. Thanks!

  61. I blog quite often and I genuinely thank you for your content. This great article has really peaked my interest. I’m going to take a note of your site and keep checking for new details about once per week. I subscribed to your Feed too.

  62. Oh my goodness! Amazing article dude! Thank you so much, However I am having troubles with your RSS. I don’t understand the reason why I am unable to subscribe to it. Is there anybody having identical RSS problems? Anyone who knows the solution can you kindly respond? Thanks!!

  63. After I originally commented I seem to have clicked on the -Notify me when new comments are added- checkbox and now every time a comment is added I get four emails with the same comment. There has to be an easy method you can remove me from that service? Thanks a lot!

  64. Hi there! I could have sworn I’ve been to this blog before but after browsing through some of the articles I realized it’s new to me. Anyhow, I’m definitely happy I discovered it and I’ll be book-marking it and checking back often!

  65. Nice post. I learn something totally new and challenging on blogs I stumbleupon every day. It will always be interesting to read through articles from other writers and use a little something from their websites.

  66. Oh my goodness! Impressive article dude! Thanks, However I am experiencing problems with your RSS. I don’t know the reason why I can’t join it. Is there anybody getting the same RSS issues? Anyone that knows the answer will you kindly respond? Thanks!!

  67. Hi, I do think this is an excellent site. I stumbledupon it 😉 I will revisit once again since i have book-marked it. Money and freedom is the best way to change, may you be rich and continue to guide others.

  68. Oh my goodness! Amazing article dude! Thank you so much, However I am having problems with your RSS. I don’t understand the reason why I am unable to subscribe to it. Is there anybody having similar RSS issues? Anybody who knows the answer can you kindly respond? Thanks!!

  69. A fascinating discussion is worth comment. I believe that you should publish more about this topic, it might not be a taboo matter but generally people don’t discuss these subjects. To the next! Best wishes!!

  70. I’m impressed, I have to admit. Seldom do I encounter a blog that’s both equally educative and engaging, and let me tell you, you’ve hit the nail on the head. The problem is something too few people are speaking intelligently about. Now i’m very happy I stumbled across this during my search for something concerning this.

  71. I would like to thank you for the efforts you have put in penning this blog. I am hoping to view the same high-grade blog posts from you later on as well. In fact, your creative writing abilities has encouraged me to get my own website now 😉

  72. Howdy! This blog post couldn’t be written any better! Looking through this article reminds me of my previous roommate! He continually kept talking about this. I will forward this information to him. Fairly certain he’s going to have a very good read. Thanks for sharing!

  73. Hi, I do believe this is an excellent site. I stumbledupon it 😉 I am going to come back once again since i have book-marked it. Money and freedom is the greatest way to change, may you be rich and continue to help other people.

  74. You’re so awesome! I do not think I’ve read anything like this before. So great to discover somebody with a few unique thoughts on this subject matter. Seriously.. thanks for starting this up. This web site is something that is required on the internet, someone with a little originality!

  75. The next time I read a blog, Hopefully it won’t fail me as much as this one. I mean, I know it was my choice to read through, however I genuinely thought you would have something interesting to say. All I hear is a bunch of crying about something that you could possibly fix if you weren’t too busy searching for attention.

  76. After looking over a number of the articles on your web site, I seriously like your technique of blogging. I added it to my bookmark webpage list and will be checking back in the near future. Take a look at my web site too and let me know how you feel.

  77. Hi! I just want to offer you a big thumbs up for your excellent info you’ve got right here on this post. I will be returning to your site for more soon.

  78. An interesting discussion is worth comment. I do believe that you need to write more on this subject matter, it may not be a taboo subject but typically people do not talk about these topics. To the next! Many thanks!!

  79. Nice post. I learn something new and challenging on blogs I stumbleupon on a daily basis. It will always be helpful to read content from other authors and practice something from other websites.

  80. I have to thank you for the efforts you’ve put in penning this blog. I’m hoping to view the same high-grade blog posts from you in the future as well. In fact, your creative writing abilities has encouraged me to get my own, personal site now 😉

  81. Aw, this was an actually wonderful article. In idea I want to place in creating such as this additionally? requiring time and also real effort to make a very good write-up? but what can I state? I postpone alot and also never appear to obtain something done.

  82. Good post. I learn something totally new and challenging on websites I stumbleupon everyday. It’s always exciting to read through content from other writers and practice something from their sites.

  83. An outstanding share! I’ve just forwarded this onto a colleague who has been conducting a little homework on this. And he actually bought me dinner due to the fact that I stumbled upon it for him… lol. So allow me to reword this…. Thank YOU for the meal!! But yeah, thanx for spending time to talk about this subject here on your web site.

  84. Hi! I could have sworn I’ve visited this site before but after looking at some of the articles I realized it’s new to me. Nonetheless, I’m certainly happy I came across it and I’ll be book-marking it and checking back regularly!

  85. I was more than happy to discover this site. I wanted to thank you for ones time due to this wonderful read!! I definitely savored every little bit of it and i also have you bookmarked to look at new information in your website.

  86. The next time I read a blog, Hopefully it won’t disappoint me just as much as this one. I mean, Yes, it was my choice to read, but I actually thought you would probably have something interesting to say. All I hear is a bunch of whining about something that you can fix if you weren’t too busy searching for attention.

  87. I must thank you for the efforts you have put in penning this website. I really hope to see the same high-grade content by you in the future as well. In truth, your creative writing abilities has motivated me to get my own site now 😉

  88. That is a very good tip especially to those new to the blogosphere. Brief but very accurate information… Appreciate your sharing this one. A must read post!

  89. Nice post. I learn something totally new and challenging on sites I stumbleupon everyday. It’s always interesting to read through articles from other writers and use something from other web sites.

  90. Greetings, There’s no doubt that your blog could possibly be having web browser compatibility issues. Whenever I look at your website in Safari, it looks fine however, if opening in Internet Explorer, it’s got some overlapping issues. I merely wanted to provide you with a quick heads up! Besides that, great website!

  91. The next time I read a blog, I hope that it won’t fail me just as much as this one. After all, I know it was my choice to read through, nonetheless I actually thought you’d have something helpful to say. All I hear is a bunch of whining about something that you could fix if you weren’t too busy seeking attention.

  92. Hello there! This blog post could not be written much better! Looking through this article reminds me of my previous roommate! He continually kept preaching about this. I am going to forward this post to him. Fairly certain he will have a very good read. Thanks for sharing!

  93. Hello there! I could have sworn I’ve been to this web site before but after going through many of the posts I realized it’s new to me. Regardless, I’m certainly pleased I stumbled upon it and I’ll be bookmarking it and checking back frequently!

  94. Oh my goodness! Amazing article dude! Thanks, However I am encountering difficulties with your RSS. I don’t understand why I can’t subscribe to it. Is there anybody else getting the same RSS issues? Anybody who knows the answer will you kindly respond? Thanks!!

  95. Having read this I believed it was very enlightening. I appreciate you spending some time and energy to put this short article together. I once again find myself spending way too much time both reading and posting comments. But so what, it was still worth it!

  96. Aw, this was an exceptionally good post. Finding the time and actual effort to produce a top notch article… but what can I say… I put things off a whole lot and don’t seem to get nearly anything done.

  97. This is the right webpage for everyone who would like to understand this topic. You realize a whole lot its almost hard to argue with you (not that I personally will need to…HaHa). You certainly put a fresh spin on a subject which has been discussed for ages. Great stuff, just great!

  98. The very next time I read a blog, Hopefully it does not fail me as much as this particular one. After all, Yes, it was my choice to read through, nonetheless I truly believed you’d have something helpful to say. All I hear is a bunch of whining about something you can fix if you were not too busy searching for attention.

  99. After going over a few of the articles on your web page, I seriously appreciate your technique of blogging. I saved as a favorite it to my bookmark webpage list and will be checking back soon. Please check out my web site as well and let me know how you feel.

  100. Right here is the right site for anyone who would like to find out about this topic. You know so much its almost tough to argue with you (not that I personally will need to…HaHa). You definitely put a brand new spin on a subject that’s been discussed for decades. Great stuff, just wonderful!

  101. When I initially commented I seem to have clicked the -Notify me when new comments are added- checkbox and now whenever a comment is added I recieve four emails with the same comment. There has to be an easy method you are able to remove me from that service? Thanks!

  102. Hi there, I believe your site could be having internet browser compatibility problems. Whenever I take a look at your web site in Safari, it looks fine but when opening in Internet Explorer, it’s got some overlapping issues. I merely wanted to give you a quick heads up! Other than that, great site!

  103. Greetings, I do think your site could be having web browser compatibility problems. When I look at your blog in Safari, it looks fine however when opening in Internet Explorer, it has some overlapping issues. I merely wanted to provide you with a quick heads up! Other than that, wonderful site!

  104. I?m pleased, I must claim. Really seldom do I experience a blog that?s both informative and entertaining, and also let me tell you, you have hit the nail on the head. Your suggestion is impressive; the issue is something that not enough people are speaking intelligently around. I am very happy that I came across this in my look for something associating with this.

  105. I really love your site.. Pleasant colors & theme. Did you create this site yourself? Please reply back as I’m attempting to create my very own blog and want to learn where you got this from or just what the theme is named. Kudos!

  106. Hi, I do believe your website could be having browser compatibility problems. When I look at your website in Safari, it looks fine however, if opening in Internet Explorer, it’s got some overlapping issues. I just wanted to give you a quick heads up! Aside from that, wonderful blog!

  107. When I initially commented I seem to have clicked the -Notify me when new comments are added- checkbox and now each time a comment is added I receive 4 emails with the exact same comment. There has to be an easy method you can remove me from that service? Kudos!

  108. I blog quite often and I seriously appreciate your content. This article has truly peaked my interest. I’m going to take a note of your blog and keep checking for new information about once a week. I opted in for your Feed as well.

  109. Hello there! I could have sworn I’ve been to this website before but after looking at a few of the articles I realized it’s new to me. Regardless, I’m certainly delighted I found it and I’ll be bookmarking it and checking back regularly!

  110. Next time I read a blog, I hope that it won’t disappoint me as much as this one. I mean, I know it was my choice to read, nonetheless I truly believed you would have something helpful to say. All I hear is a bunch of complaining about something you can fix if you were not too busy searching for attention.

  111. When I initially left a comment I seem to have clicked the -Notify me when new comments are added- checkbox and now whenever a comment is added I recieve four emails with the same comment. Is there a means you can remove me from that service? Thank you!

  112. Hi there! This blog post couldn’t be written much better! Reading through this article reminds me of my previous roommate! He constantly kept preaching about this. I most certainly will send this post to him. Fairly certain he’s going to have a good read. Thank you for sharing!

  113. May I simply say what a relief to discover somebody that genuinely knows what they are talking about over the internet. You certainly understand how to bring a problem to light and make it important. More people need to look at this and understand this side of your story. I can’t believe you are not more popular since you certainly possess the gift.

  114. After study a few of the post on your web site currently, and also I really like your way of blog writing. I bookmarked it to my bookmark website list as well as will certainly be checking back soon. Pls take a look at my internet site also and let me know what you believe.

  115. I was very pleased to discover this web-site. I wanted to many thanks for your time for this remarkable read!! I absolutely enjoying every little bit of it and I have you bookmarked to look into brand-new things you post.

  116. An interesting discussion is worth comment. I believe that you need to write a lot more on this topic, it could not be a forbidden topic however generally individuals are insufficient to talk on such topics. To the next. Thanks

  117. I?d have to get in touch with you here. Which is not something I generally do! I enjoy checking out a blog post that will make people think. Additionally, thanks for allowing me to comment!

  118. I love your blog.. very nice colors & theme.
    Did you design this website yourself or did you hire someone to do it for you?
    Plz respond as I’m looking to design my own blog and would like to know where u got this from.

    thanks a lot

  119. You’ve made some really good points there. I looked on the internet for more information about the issue and
    found most people will go along with your views on this site.

댓글 남기기