I am pretty new to database section. I tried porting a table created in Oracle to SQL Server 2005. In Oracle, i could see a column defined holding the user details.
CREATE_USER VARCHAR2(255 BYTE) DEFAULT USER NOT NULL
My doubt is reg default value USER.
I would like to know
1) What will be the value keyword "USER" will be returning. Is it an in built property or function anything which returns the default user?
2) the equivalent value to be used for "USER" in SQL Server 2005?