Extended Properties Editor

Set Extended Properties Name List

What Name List do?

This is name select list of Extended Properties.It can accelerate your input,and administer Extended Properties Name in the database.

What Are Extended Properties (excerpt from SQL 2000 Books Online)?

Microsoft SQL Server 2000 introduces extended properties that users can define on various objects in a database. These extended properties can be used to store application-specific or site-specific information about the database objects. Because the property is stored in the database, all applications reading the property can evaluate the object in the same way. This helps enforce consistency in how data is treated by all of the programs in the system.

Each extended property has a user-defined name and value. The value of an extended property is a sql_variant that can contain up to 7500 bytes of data. Individual database objects can have multiple extended properties.

There is no convention or standard for defining extended properties. The database designer sets the rules specifying the property names and contents when the database is designed, and then the applications accessing the database have to be coded to follow those rules or conventions.

How to use this tool?

1.Click "Main->Tools->Extended Properties Administrator";

2.Click "Browse Object Tree" to select the item you intend to add Extended Properties;

3.Add/Drop Extended Properties of current item.