Of Interest
Be responsible for your future
Enter the USA legally!
Visa, Green Card, Citizenship, Passport
Consultation Services
|
Sybase
»
DDL
»
Design
»
Alter
Altering a table
Alter table examples:
alter table employee add cell_no numeric(10) null
go
alter table employee drop constraint 'emp_dept_constr'
go
/* add default */
alter table charge_item replace price_overridable_ind default 0
go
/* change column name -- quotes are required */
sp_rename 'employee.dept',dept_name
go
|
|
|
Get the latest Rocket99 news and tech tips via
|
