Alter procedure sp_columnscript @tablename varchar (50), @columnname varchar (50) = nullas / **************************************************************** : 2003-04-09 Modifier: wu Remarks: Note for a table: ************************************* / DECLARE @tmpPos int if @columnname is null begin set @tmpPos = CHARINDEX (, @tablename '.') set @columnname = right (@tablename, len (@tablename) - @tmpPos) set @tablename = left (@tablename, @ TMPOS - 1) END
Select * from :: Fn_ListextendedProperty (NULL, 'User', 'DBO', 'Table', @tablename, 'Column', @Columnname) Add this stored procedure, add the corresponding shortcuts in the tool, custom, For example, in Ctrl 3 specify sp_columnscript and then select Table.Column in the Query Analyzer to select this text, press CTRL 3.
