mssql 使用

查询某个字段在哪些表有


SELECT OBJECT_NAME(id) objName,
       name AS colName
FROM syscolumns
WHERE (name LIKE 'tickerSymbol')
      AND id IN (
                    SELECT id FROM sysobjects WHERE xtype = 'u'
                )

备份表

SELECT * INTO [备份后表名_年月日小时分钟_备份原因] FROM dbo.[要备份的表]