Refreshing a database or table with management tools
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.
精彩评论