Post reply

My first Query

  • May 3, 2010 at 12:32 am

    #221156

    Hello ! Guys

    I have newly joined this forum, I have a query regarding a create table statement which I have generated successfully and its look like :

    IF OBJECT_ID('dbo.Nums','U') IS NOT NULL DROP TABLE dbo.Nums;

    CREATE TABLE dbo.Nums( n INT NOT NULL PRIMARY KEY);

    My question is what stands for 'U' here , and what if I don't want to mention the 'U' here?

    I haven't experimented that really.

    Thanks

    Subhro

  • May 3, 2010 at 12:43 am

    #1161098

    Here the 'U' is the object type which is a table.if you dont put 'U' still the query works, but think if you are having a SP or a Funtion with the same name as table it will give conflict.

    the diffrent types are as follows:

    D

    F

    IT

    P

    PK

    S

    SQ

    TR

    U

    UQ

    V

  • May 3, 2010 at 1:16 am

    #1161112

    Thanks Sharath!

  • May 3, 2010 at 1:23 am

    #1161119

    mukherjee.subhro (5/3/2010)

    My question is what stands for 'U' here , and what if I don't want to mention the 'U' here?

    I haven't experimented that really.

    IF OBJECT_ID(N'dbo.Nums', N'U') IS NOT NULL

    DROP TABLE dbo.Nums;

    GO

    CREATE TABLE dbo.Nums (n INTEGER NOT NULL PRIMARY KEY);

    The U means only match with user tables.

    You can use any object type there like V for a view, see sys.objects in Books Online for a list.

    Otherwise, it checks for any object with the name given.

    Paul White
    All articles available on SQL.kiwi
    @SQL_Kiwi

  • May 3, 2010 at 1:31 am

    #1161123

    Got it ! Thanks

    subhro

  • May 3, 2010 at 1:34 am

    #1161125

    Sorry for the duplication - I didn't see the reply from sharath.chalamgari because I had the reply window open for a while before submitting it :pinch:

    Paul White
    All articles available on SQL.kiwi
    @SQL_Kiwi

Viewing 6 posts - 1 through 6 (of 6 total)

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