USE <database_name>;GOSELECT SCHEMA_NAME(schema_id) AS schema_name,name AS table_nameFROM sys.tablesWHERE OBJECTPROPERTY(OBJECT_ID,'lslndexed') = 0ORDER BY schema_name, table_name;GO
No comments:
Post a Comment