CODEWITHSUNDEEP
sql-server
John
John

Reputation: 647

How to put a description in an sql server database

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

Upvotes: 8

Views: 3169

Answers (2)

John
John

Reputation: 647

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

Upvotes: 11

A ツ
A ツ

Reputation: 1267

if you are using mssm you can use "Registered Server", that way you can name and describe them , even sort them in groups

Upvotes: 0

Related Questions