SP_ADDEXTENDEDPROPERTY
----We can give definitions for tables.
EXEC SP_ADDEXTENDEDPROPERTY
@name = N'MS_Description',
@value = N'This Table is Telling about Emplyee Information.And also Employer',
@level0type = N'SCHEMA', @level0name = dbo,
@level1type = N'TABLE', @level1name = EmployeeTable;
And also we can do the same thing in Table->RightClick->Properties->Extended Properties.
EXEC SP_ADDEXTENDEDPROPERTY
@name = N'MS_Description',
@value = N'This Table is Telling about Emplyee Information.And also Employer',
@level0type = N'SCHEMA', @level0name = dbo,
@level1type = N'TABLE', @level1name = EmployeeTable;
And also we can do the same thing in Table->RightClick->Properties->Extended Properties.
Comments