Sql Tutorial Class


SQL Lesson Topic
1.Sql Query Classes
2.Create a database
3.Drop database
4.Database Rename

5.Data Type
6.Create table sql
7.Insert into table
8.Select Statement
7.1.Primary key
7.2.UNIQUE Key
7.3.FOREIGN Key
7.4.Check Constraint
7.5.Default SQL
7.6.Delete Statement
7.7.Truncate Table
7.8.Update Stat.
7.9.DROP Table

9.Custom column Heading
10.Sql Select Where
11.Operators
12.Greater than Equalto
13.Greater than
14.Less than
15.Less than equalto
16.SQL SUM()
17.SQL MAX()
18.SQL MIN()
19.SQL AVG()
20.SQL COUNT()
21.Like Wildcard(%)
22.Like Wildcard(_)
23.Like Wildcard []
24.Like wildcard [^]
25.AND Operator
26.OR Operator
27.NOT Operator
28.IS NULL
29.IS NOT NULL
30.IN KeywordL
31.NOT IN Keyword
32.Between
33.Not Between
34.Distinct keyword
35.SELECT INTO
36.Insert into Select
37.ORDER BY ASC
38.ORDER BY DESC
39.SQL TOP 10
40.HAVING Clause
41.UNION Clause
42.Date Format


Sql database rename

Sql server database rename








Change the name of the SQL server database: after creating the database on the SQL server. Sometimes it is necessary to rename the existing database. The user does not want to create a database in each type. It is not a good idea for the user of the sql server. To change the name of the sql server database you can use the sql or tsql command.

It is very easy to change the sql server database name.

 Syntax:
          sp_renamedb 'OLD_SQL_SERVER_DATABASE_NAME', 'NEW_SQL_SERVER_DATABASE_NAME'


Example:
                   
               Create Database ItemDetails
               sp_renamedb 'ItemDetails', 'Items'

[Note: The ItemDetails database is created in previous lesson.]

Some particles for sql server database rename:

Create Database KFCHotel  
Create Database MacdonaldItams 


Renaming:


sp_renamedb 'KFCHotel', 'KFC5Star'
sp_renamedb 'MacdonaldItams', 'MacdonaldType'







Sql server database rename in image

sql server database rename by tsql


Labels:

No comments:

Post a Comment

Amazon Today's Deals

Amazon Best Sellers

DMC