table

Question

table

PJ_SQL

SSCertifiable

Points: 6703
More actions
January 4, 2016 at 4:04 pm

#310585

What does this mean?
CREATE TABLE [dbo].[A](
[TimestampCreate] [dbo].[TimestampCreate] NOT NULL
)
dbo.timestampcreate mean?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 1

PJ_SQL (1/4/2016)
What does this mean?
CREATE TABLE [dbo].[A](
[TimestampCreate] [dbo].[TimestampCreate] NOT NULL
)
dbo.timestampcreate mean?

Are you using MySQL/MariaDB? This is an enumeration/identity column on those rdbms

😎

matak SSCrazy Points: 2674 More actions · Answer 2

This could also be for a user defined type.

You would need to check the definition of the type to see what it is referencing.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

matak (1/4/2016)
This could also be for a user defined type.
You would need to check the definition of the type to see what it is referencing.

That would be my guess, as well.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)