1.
Create new
database take 3MB memory in hard disk.
1 MB for log file
2 MB for Data
file
2.
A table in sql
server 2005 can have only one clustered index and up to 249 non clustered
indices.
3. We can nest store
procedure and managed code reference up to 32 level .
4.
Rename a Database
Syntax:
sp_renamedb
‘oldName' , ‘newName'
implementation
sp_renamedb 'RSS' , 'RSS1'
Here sp_renamedb is predefine means inbulid store
procedure name. RSS is original database name
that will be change and RSS1 is new database
name means updated name of original database. Database names should be write in
' ' (single quates).
5. Rename a Table
Syntax
sp_rename ‘oldTableName' , ‘newTableName'
Implementation
sp_rename
'Articles' , 'Blog'
Here sp_rename is predefine means inbulid store
procedure name. Articles is original table name
that will be change and Blog is new table name
means updated name of original table. Table names should be write in ' ' (single quates).But you are sure here that you are
working in that database where Articles exists.
6. Rename a Column
Syntax
sp_rename ‘tableName.tableColumnName'
,'newColumnName','Column'
Implemantation
sp_rename
'Blog.Title' ,'Heading','Column'
Here sp_rename is predefine means inbulid store
procedure name. Blog is Table name. Title is column name that in Blog
Table that will be change. Heading is new
column name means updated name of Title column. Column represents we are changing in column name. column
names should be write in ' ' (single quates).