create table - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

create table

Author

Topic

eugz
Posting Yak Master

210 Posts

Posted - 2009-04-08 : 11:49:22

Hi All.
Can somebody explaine what wrong in this code:

CREATE TABLE ABC(
    ABC_ID int IDENTITY(1,1) NOT NULL,
    ABC_Time datetime NOT NULL
    CONSTRAINT DF_DepartmentABC_ABC_Time DEFAULT (GETDATE()),
    CONSTRAINT PK_DepartmentABC PRIMARY KEY CLUSTERED
        (
            ABC_ID ASC
        )

Thanks.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2009-04-08 : 12:29:45

ABC_ID int IDENTITY(1,1) PRIMARY KEY CLUSTERED

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL or How to sell Used Cars
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources