hi folks, what's the best way to DROP MS SQL table? can this be done from Winhost CP or do i have to write my own code?
You should be able to drop tables using SQL Server Management Studio. Please read our knowledge base article on how to connect to your SQL database using SQL Server Management studio here: http://support.Winhost.com/KB/a1033/how-to-connect-to-sql-server-using-sql-server-management.aspx Once connected you will be able to drop the table using T-SQL. Instructions can be found here: http://msdn.microsoft.com/en-us/library/ms173790.aspx and here: http://www.w3schools.com/sql/sql_drop.asp