1:- Change Database Name using Query
Alter database Test modify name=Test1
you can also use system stored procedure
sp_renameDB 'Test1','Test'
2:- How to get all table name from database
First select database and run below query.
SELECT name FROM sys.tables
3:- How to Get All stored procedures in database.
SELECT ROUTINE_SCHEMA, ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE';
4:- Check Size of database
Run sp_spaceused Stored Procedure
exec sp_spaceused
2:- ShortCut Key
| Command Name | Shortcut Keys |
|---|---|
| Execute | F5 |
| Execute Current Statement | F8 |
| SQL Query History | CTRL+ALT+H |
| Edit Parameters | CTRL+SHIFT+P |
| Hide/Show additional document views | CTRL+R |
| Comment Selection | CTRL+K, C |
| UnComment Selection | CTRL+K, U |
| Go To Definition | F12 |
