Basic Queries...

--IF THE TABLE IS Exist
INSERT INTO TestTable (FirstName, LastName)
SELECT FirstName, LastName
FROM Person.Contact
--------------------------------
--IF THE TABLE IS NOT Exist
SELECT *
INTO DISHSEGMENTDETAIL
FROM TEMPDISHSEGMENTDETAIL
-------------------------------
SP_RENAME 'NEWTABLENAME','OLDTABLENAME'
-------------------------------------
--Rename the column
SP_RENAME 'DISHSEGMENTDETAIL.SEG_DETAIL_DATETIME','Seg_Detail_UpdateTime'
-------------------------------------
EXEC sp_renamedb 'adminv2_lawrence', 'newName'
alter database newName modify name=adminv2_lawrenc
---------------------------------------------------------
IF EXISTS (select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Employee' and COLUMN_NAME='Name')
BEGIN
ALTER TABLE Employee
ALTER COLUMN Name varchar (30)
END
---------------------------------------------------------