易丰科技
标题:
新增/修改 SQL 2008 Table 扩充属性
[打印本页]
作者:
Calvin
时间:
2011-10-7 10:08
标题:
新增/修改 SQL 2008 Table 扩充属性
string cmdText = string.Empty;
if (string.IsNullOrEmpty(current))
cmdText = string.Format("sys.sp_addextendedproperty @name=N'YF_Description', @value=N'{0}' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'{1}'",
type, tableName);
else
cmdText = string.Format("sys.sp_updateextendedproperty @name=N'YF_Description', @value=N'{0}' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'{1}'",
type, tableName);
TABLESTableAdapter adapter = new TABLESTableAdapter();
SqlCommand cmd = new SqlCommand(cmdText, adapter.Connection);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
复制代码
欢迎光临 易丰科技 (http://forum.yftek.com/)
Powered by Discuz! X3