如何在SQL Server中删除sys.tables数据 [英] how to delete sys.tables data in sql server

问题描述

如何根据日期时间删除所有sys.tables数据.

假设我在一个数据库中有10个表并且没有datetime列，那么如何在startdate和enddate之间删除这10个表(我对该表有30天的信息.我要删除两个日期之间的20天信息)

how to delete all sys.tables data based on datetime.

suppose i have 10 tables in one database and don''t have datetime column, then how to delete on that 10 tables between startdate and enddate(i have 30 days infromation on that tables. i am deleting 20 days information between the dates)

how it is possible.

推荐答案

如果您没有datetime列，则无法过滤要删除的数据.

If you don''t have a datetime column then there is no way of filtering the data to delete.

这篇关于如何在SQL Server中删除sys.tables数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！