SQL Server database Dictionary maintenance method

Enable SQL Server Enable manager, take 2008 as an example

1. Set Table information description

• Select the table you want to set, right-click on "Properties"

、

• Select Extended Properties

Fill in the requirements:

Name: ms_description

Value: module name-table name

modifying statements

DECLARE @tableName varchar (200)

DECLARE @tableDesc varchar (200)

DECLARE @sql varchar (8000)

DECLARE @c int

Set @tableName = N ' B_YHBM '; --Table name

Set @tableDesc = N ' Organization-person login information '; --Description information (requires module + table description) such as main program-Permission category

--Determine if you have completed

Select @c = COUNT (*) from sys.extended_properties a WHERE a.major_id = object_id (@TableName) and name = ' Ms_description ' A nd minor_id = 0;

IF @c <= 0

BEGIN--Add

EXEC [SYS]. [Sp_addextendedproperty] @name = n ' ms_description ', @value = @tableDesc, @level0type = N ' SCHEMA ', @level0name = n ' dbo ', @l Evel1type = N ' TABLE ', @level1name = @tableName;

END

ELSE

BEGIN--Modify

EXEC [SYS]. [Sp_updateextendedproperty] @name = n ' ms_description ', @value = @tableDesc, @level0type = N ' SCHEMA ', @level0name = n ' dbo ', @level1type = N ' TABLE ', @level1name = @tableName;

END

GO

2, fill in paragraph description

Select the table you want to set, right-click on "Design"

3. Output information

See http://www.cnblogs.com/netWild/archive/2013/04/19/3031734.html

Output execution statement SQL statement. txt

Output effect:

SQL Server database Dictionary maintenance method