Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nomaneagle
Starting Member
18 Posts |
 Posted - 2008-11-12 : 12:17:02
|
| I have created some Sql Views in my database. And I want to keep information about the views. e.g; I want to put my remarks about the reason why I created Sql View and other information. So in the future if I want to get rid of any view, I can check the reason why I created that view. Any Clue? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-12 : 12:22:43
|
| just put as comments inside view body itself. use /* & */ for start and end of coment section like/* This view was created for blah blah blah */ |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-12 : 12:23:43
|
| Or you can use Extended properties to reflect metadata and query it as well. |
|
|
|
nomaneagle
Starting Member
18 Posts |
Posted - 2008-11-12 : 12:29:31
|
| Thanks guys |
|
|
|
MartinSmith
Starting Member
17 Posts |
Posted - 2008-11-14 : 11:23:07
|
| I would use the extended properties.If you try using inline comments you will lose them if any one ever uses the "Design View" function and saves. |
|
|
|
|
|
|
Where can I put my remarks in Sql Views?