Top 8 Important commands in SQL

HI All, In this video i have told about some important command in SQL which generally helps us to work on case sensitive task. please let me know if you have any kind question or you want me to create the video on any topic you may share me on [email protected] Below is the Query: --How to delete All tables in specific database. use Today exec sp_MSforeachtable 'drop table ?' --How to get Server Name by executng command in SQL select @@SERVERNAME --How to get details of any table using help command Use Deveolper sp_help 'Aakash' --How to get details of anydatabase using help command sp_helpdb 'Deveolper' --How to rename database Name sp_renamedb 'Deveolper','Data' --How to Rename table in SQL Sp_rename 'Data.dbo.Aakash','Aku' --How to rename column name in Table. select * from aku sp_rename 'Data.dbo.aku.Sales','Amount' --How to show all tables in one line of query in SQL. Select * from sys.tables