create table Zakaz
(
ZakazID int identity(1,1) not null primary key,
Meno varchar(50) not null,
Priezvisko varchar(50) not null
)

alter table Zakaz
add Ulice varchar(50) null

alter table Zakaz
drop column Ulice

alter table Zakaz
alter column Meno varchar(255) null

Stlpec:
sp_rename 'Zakaz.Meno','KrstneMeno','Column'

Tabulka:
sp_rename 'Zakaz','Predavac'


___________________________________________________________________

CREATE DATABASE [MojeDB] ON PRIMARY
(
NAME = N'MojeDB', FILENAME = N'D:\mssql\data\MojeDB.mdf' ,
SIZE = 2048KB , FILEGROWTH = 1024KB
)
LOG ON
(
NAME = N'MojeDB_log', FILENAME = N'D:\mssql\log\MojeDB_log.ldf',
SIZE = 1024KB , FILEGROWTH = 10%
)