Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to put a description in an sql server database

Tags:

sql-server

I use SQL Server Express 2012 and have multiple SQL Server databases and sometimes it gets difficult to find out which is which. So I want to put a description on each database. But I am not able to find any such option in the management studio. Has anybody faced this problem and knows the solution

like image 543
John Avatar asked Mar 25 '15 06:03

John


Video Answer


1 Answers

Got the answer now. We can use Extended properties.

Right click DBName in object explorer - > Properties -> Extended properties

In that I added "Description" under name and details under value. We can add more properties also if we want. Same can be done for Tables too

like image 166
John Avatar answered Jan 03 '23 22:01

John