How to judge that the table that is not in the current database has been opened

1 Answers

1. +4Votes  

   Use

   USed (your table name)

   Song Sijian is fine

   Return t means that it has been opened

   Question: Try, invalid.The table is released in the default directory, but the reason is not at the current database.

   From Guangdong

   答: The available for testing (as shown below)
   This is a function that judges whether the current table is open, which has nothing to do with the location of the table

   From Jiangsu

   Question: I didn’t make it clear, the table was opened by other databases.

   From Guangdong

   Questions: Regardless of whether the other database is opened, the USED () returns.

   From Guangdong

   Answer: Other databases?Are you sharing files or other methods, sending the specific relevant code of the open.

   From Jiangsu

   Sean Reynolds- March 18, 2023 |