Declaring the datatype for a column in a table

Use the following syntax to declare the datatype of a new column in a create table or an alter table statement:

create table [[database.]owner.]table_name 
		(column_name datatype [identity | not null | null]
			[, column_name datatype [identity | not null |
				null]]...)

alter table [[database.]owner.]table_name 
		add column_name datatype [identity | null 
		[, column_name datatype [identity | null]... 

For example:

create table sales_daily
    (stor_id char(4)not null,
     ord_num numeric(10,0)identity,
     ord_amt money null)