开发者

Refreshing a database or table with management tools

开发者 https://www.devze.com 2023-04-05 15:45 出处：网络

In SQL Server Management Studio there is an option to refresh a table / database? Is there a similar option for Oracle? If yes how do I do this? Is there a command to run to do this? Lastly what does

相关专题：oracle sql-server ssms

In SQL Server Management Studio there is an option to refresh a table / database?

Is there a similar option for Oracle? If yes how do I do this? Is there a command to run to do this? Lastly what does the refresh actua开发者_Python百科lly do? Does it commit the latest data and break locks?

I assume you're talking about the context menu item.

The Refresh option just means it will request the structure of the table (keys, columns, constraints, and so on) again from SQL Server. It has nothing to do with data, locks, committing changes or anything like that.

This menu option is also available for other objects (like database) in the tree view for a SQL Server database in SSMS.

With SQL server you can use SQL Developer to refresh tables.