Pubudu


Hi,

This question refers to, How do I refresh the database using SQL.

Refreshing mean just right clicking on the database, we can see the Refresh on the context menu.Thats what i ment.

Thanks





Re: How to Refresh database using SQL

Arnie Rowland



Please give more information about what you mean by 'refresh the database'





Re: How to Refresh database using SQL

Chris Howarth

If you mean that you're either trying to refresh a database node in Object Explorer in SQL Server Management Studio or a database node in the server pane in Enterprise Manager, then there is no way of performing these tasks using T-SQL.

Chris







Re: How to Refresh database using SQL

Manivannan.D.Sekaran

Simple Answer NO. There is T-SQL command.

You may be looking for something like DOS-Command (clear/cls). If you need on your UI you have to use SMO/DMO.