How to fix “There is already an object named ' ' in the database” error in sql server












1















I have created this table, I can't enter data manually because of this error.



    USE [Butterfly]

    GO



    SET ANSI_NULLS ON

    GO



    SET QUOTED_IDENTIFIER ON

    GO



    CREATE TABLE [dbo].[VM_Vehicles](

        [VehicleID] [nvarchar](100) NOT NULL,

        [VehicleType] [nvarchar](100) NULL,

        [RegistrationNo] [nvarchar](100) NULL,

        [PurchaseDate] [date] NULL,

        [Make] [nvarchar](100) NULL,

        [Model] [nvarchar](100) NULL,

        [ChassisNo] [nvarchar](100) NULL,

        [EngineNo] [nvarchar](100) NULL,

        [EngineCapacity] [nvarchar](100) NULL,

        [YearofManufacture] [nvarchar](100) NULL,

        [SeatingCapacity] [nvarchar](100) NULL,

        [ContactName] [nvarchar](100) NULL,

        [Phone] [nvarchar](50) NULL,

        [VendorID] [int] NOT NULL,

        [Picture] [image] NULL,

        [VoucherNo] [int] NOT NULL,



     CONSTRAINT [PK_VM_Vehicles1] PRIMARY KEY CLUSTERED 

    (

        [VehicleID] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



    GO


I have tried using this code to find what's wrong with my database. so far no luck finding error.



IF object_id("tempdb..#VM_Vehicles") is not null

DROP TABLE #VM_Vehicles

CREATE TABLE #VM_Vehicles (vehicleID nvarchar(100), ...);


I already tried changing constraint name and table name. That didn't provide me a answer either.






sql-server







share|improve this question

























  • Regarding how to create a table only if it does not exist, read this SO question. As for your error, there could be a number of reasons why you have stale objects.

    – Tim Biegeleisen
    Nov 21 '18 at 10:52






  • 2





    #VM_Vehicles <> [dbo].[VM_Vehicles]. One is a temporary table, and another is a persistant table.

    – Larnu
    Nov 21 '18 at 10:58
















1















I have created this table, I can't enter data manually because of this error.



    USE [Butterfly]

    GO



    SET ANSI_NULLS ON

    GO



    SET QUOTED_IDENTIFIER ON

    GO



    CREATE TABLE [dbo].[VM_Vehicles](

        [VehicleID] [nvarchar](100) NOT NULL,

        [VehicleType] [nvarchar](100) NULL,

        [RegistrationNo] [nvarchar](100) NULL,

        [PurchaseDate] [date] NULL,

        [Make] [nvarchar](100) NULL,

        [Model] [nvarchar](100) NULL,

        [ChassisNo] [nvarchar](100) NULL,

        [EngineNo] [nvarchar](100) NULL,

        [EngineCapacity] [nvarchar](100) NULL,

        [YearofManufacture] [nvarchar](100) NULL,

        [SeatingCapacity] [nvarchar](100) NULL,

        [ContactName] [nvarchar](100) NULL,

        [Phone] [nvarchar](50) NULL,

        [VendorID] [int] NOT NULL,

        [Picture] [image] NULL,

        [VoucherNo] [int] NOT NULL,



     CONSTRAINT [PK_VM_Vehicles1] PRIMARY KEY CLUSTERED 

    (

        [VehicleID] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



    GO


I have tried using this code to find what's wrong with my database. so far no luck finding error.



IF object_id("tempdb..#VM_Vehicles") is not null

DROP TABLE #VM_Vehicles

CREATE TABLE #VM_Vehicles (vehicleID nvarchar(100), ...);


I already tried changing constraint name and table name. That didn't provide me a answer either.






sql-server







share|improve this question

























  • Regarding how to create a table only if it does not exist, read this SO question. As for your error, there could be a number of reasons why you have stale objects.

    – Tim Biegeleisen
    Nov 21 '18 at 10:52






  • 2





    #VM_Vehicles <> [dbo].[VM_Vehicles]. One is a temporary table, and another is a persistant table.

    – Larnu
    Nov 21 '18 at 10:58














1












1








1








I have created this table, I can't enter data manually because of this error.



    USE [Butterfly]

    GO



    SET ANSI_NULLS ON

    GO



    SET QUOTED_IDENTIFIER ON

    GO



    CREATE TABLE [dbo].[VM_Vehicles](

        [VehicleID] [nvarchar](100) NOT NULL,

        [VehicleType] [nvarchar](100) NULL,

        [RegistrationNo] [nvarchar](100) NULL,

        [PurchaseDate] [date] NULL,

        [Make] [nvarchar](100) NULL,

        [Model] [nvarchar](100) NULL,

        [ChassisNo] [nvarchar](100) NULL,

        [EngineNo] [nvarchar](100) NULL,

        [EngineCapacity] [nvarchar](100) NULL,

        [YearofManufacture] [nvarchar](100) NULL,

        [SeatingCapacity] [nvarchar](100) NULL,

        [ContactName] [nvarchar](100) NULL,

        [Phone] [nvarchar](50) NULL,

        [VendorID] [int] NOT NULL,

        [Picture] [image] NULL,

        [VoucherNo] [int] NOT NULL,



     CONSTRAINT [PK_VM_Vehicles1] PRIMARY KEY CLUSTERED 

    (

        [VehicleID] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



    GO


I have tried using this code to find what's wrong with my database. so far no luck finding error.



IF object_id("tempdb..#VM_Vehicles") is not null

DROP TABLE #VM_Vehicles

CREATE TABLE #VM_Vehicles (vehicleID nvarchar(100), ...);


I already tried changing constraint name and table name. That didn't provide me a answer either.






sql-server







share|improve this question
















I have created this table, I can't enter data manually because of this error.



    USE [Butterfly]

    GO



    SET ANSI_NULLS ON

    GO



    SET QUOTED_IDENTIFIER ON

    GO



    CREATE TABLE [dbo].[VM_Vehicles](

        [VehicleID] [nvarchar](100) NOT NULL,

        [VehicleType] [nvarchar](100) NULL,

        [RegistrationNo] [nvarchar](100) NULL,

        [PurchaseDate] [date] NULL,

        [Make] [nvarchar](100) NULL,

        [Model] [nvarchar](100) NULL,

        [ChassisNo] [nvarchar](100) NULL,

        [EngineNo] [nvarchar](100) NULL,

        [EngineCapacity] [nvarchar](100) NULL,

        [YearofManufacture] [nvarchar](100) NULL,

        [SeatingCapacity] [nvarchar](100) NULL,

        [ContactName] [nvarchar](100) NULL,

        [Phone] [nvarchar](50) NULL,

        [VendorID] [int] NOT NULL,

        [Picture] [image] NULL,

        [VoucherNo] [int] NOT NULL,



     CONSTRAINT [PK_VM_Vehicles1] PRIMARY KEY CLUSTERED 

    (

        [VehicleID] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



    GO


I have tried using this code to find what's wrong with my database. so far no luck finding error.



IF object_id("tempdb..#VM_Vehicles") is not null

DROP TABLE #VM_Vehicles

CREATE TABLE #VM_Vehicles (vehicleID nvarchar(100), ...);


I already tried changing constraint name and table name. That didn't provide me a answer either.






sql-server




sql-server






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 21 '18 at 11:26









Mohammad

15.4k123361




15.4k123361










asked Nov 21 '18 at 10:48









MarsMars

61




61













  • Regarding how to create a table only if it does not exist, read this SO question. As for your error, there could be a number of reasons why you have stale objects.

    – Tim Biegeleisen
    Nov 21 '18 at 10:52






  • 2





    #VM_Vehicles <> [dbo].[VM_Vehicles]. One is a temporary table, and another is a persistant table.

    – Larnu
    Nov 21 '18 at 10:58



















  • Regarding how to create a table only if it does not exist, read this SO question. As for your error, there could be a number of reasons why you have stale objects.

    – Tim Biegeleisen
    Nov 21 '18 at 10:52






  • 2





    #VM_Vehicles <> [dbo].[VM_Vehicles]. One is a temporary table, and another is a persistant table.

    – Larnu
    Nov 21 '18 at 10:58

















Regarding how to create a table only if it does not exist, read this SO question. As for your error, there could be a number of reasons why you have stale objects.

– Tim Biegeleisen
Nov 21 '18 at 10:52





Regarding how to create a table only if it does not exist, read this SO question. As for your error, there could be a number of reasons why you have stale objects.

– Tim Biegeleisen
Nov 21 '18 at 10:52




2




2





#VM_Vehicles <> [dbo].[VM_Vehicles]. One is a temporary table, and another is a persistant table.

– Larnu
Nov 21 '18 at 10:58





#VM_Vehicles <> [dbo].[VM_Vehicles]. One is a temporary table, and another is a persistant table.

– Larnu
Nov 21 '18 at 10:58












1 Answer
1






active

oldest

votes


















3














You are creating a persistent table VM_Vehicles in database Butterfly. However, you are checking a temporary table #VM_Vehicles in database TempDB:



IF object_id("tempdb..#VM_Vehicles") is not null


So you are checking another table from another database and so you have a such error:




There is already an object named ' ' in the database




The correct check statement should look like this:



USE Butterfly



IF OBJECT_ID("VM_Vehicles") IS NOT NULL DROP TABLE VM_Vehicles



CREATE TABLE [dbo].[VM_Vehicles](VehicleID nvarchar(100), ...);





share|improve this answer

























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53410438%2fhow-to-fix-there-is-already-an-object-named-in-the-database-error-in-sql-s%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    3














    You are creating a persistent table VM_Vehicles in database Butterfly. However, you are checking a temporary table #VM_Vehicles in database TempDB:



    IF object_id("tempdb..#VM_Vehicles") is not null


    So you are checking another table from another database and so you have a such error:




    There is already an object named ' ' in the database




    The correct check statement should look like this:



    USE Butterfly
    

    
IF OBJECT_ID("VM_Vehicles") IS NOT NULL DROP TABLE VM_Vehicles
    

    
CREATE TABLE [dbo].[VM_Vehicles](VehicleID nvarchar(100), ...);





    share|improve this answer






























      3














      You are creating a persistent table VM_Vehicles in database Butterfly. However, you are checking a temporary table #VM_Vehicles in database TempDB:



      IF object_id("tempdb..#VM_Vehicles") is not null


      So you are checking another table from another database and so you have a such error:




      There is already an object named ' ' in the database




      The correct check statement should look like this:



      USE Butterfly
      

      
IF OBJECT_ID("VM_Vehicles") IS NOT NULL DROP TABLE VM_Vehicles
      

      
CREATE TABLE [dbo].[VM_Vehicles](VehicleID nvarchar(100), ...);





      share|improve this answer




























        3












        3








        3







        You are creating a persistent table VM_Vehicles in database Butterfly. However, you are checking a temporary table #VM_Vehicles in database TempDB:



        IF object_id("tempdb..#VM_Vehicles") is not null


        So you are checking another table from another database and so you have a such error:




        There is already an object named ' ' in the database




        The correct check statement should look like this:



        USE Butterfly
        

        
IF OBJECT_ID("VM_Vehicles") IS NOT NULL DROP TABLE VM_Vehicles
        

        
CREATE TABLE [dbo].[VM_Vehicles](VehicleID nvarchar(100), ...);





        share|improve this answer















        You are creating a persistent table VM_Vehicles in database Butterfly. However, you are checking a temporary table #VM_Vehicles in database TempDB:



        IF object_id("tempdb..#VM_Vehicles") is not null


        So you are checking another table from another database and so you have a such error:




        There is already an object named ' ' in the database




        The correct check statement should look like this:



        USE Butterfly
        

        
IF OBJECT_ID("VM_Vehicles") IS NOT NULL DROP TABLE VM_Vehicles
        

        
CREATE TABLE [dbo].[VM_Vehicles](VehicleID nvarchar(100), ...);






        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited Nov 21 '18 at 12:37

























        answered Nov 21 '18 at 11:44









        StepUpStepUp

        7,39674473




        7,39674473






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53410438%2fhow-to-fix-there-is-already-an-object-named-in-the-database-error-in-sql-s%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            Popular posts from this blog

            Create new schema in PostgreSQL using DBeaver

            Image
            0 At the beginning of my current job I had limited access to DB but recently my role is changed to superuser, admin, and owner. My colleague who was the previous DB admin is able to create a schema or change the permissions as there is a permission tab in the properties and he can change permissions by clicking easily. Would you please let me know how I can create schema and change permissions as well? Why his dbeaver looks different from me? He can easily right click on the schema folder on top of all schemas on the left side column and select create new schema while I do not have that, like the following picture I found on the internet. postgresql database-schema dbeaver share | improve this question
            Read more

            Deepest pit of an array with Javascript: test on Codility

            Image
            0 $begingroup$ This is the question from a Codility test, as a task in an interview: DeepestPit - problem description A non-empty zero-indexed array A consisting of N integers is given. A pit in this array is any triplet of integers (P, Q, R) such that: ·         0 ≤ P < Q < R < N; ·         sequence [A[P], A[P+1], ..., A[Q]] is strictly decreasing, i.e. A[P] > A[P+1] > ... > A[Q]; ·         sequence A[Q], A[Q+1], ..., A[R] is strictly increasing, i.e. A[Q] < A[Q+1] < ... < A[R]. The depth of a pit (P, Q, R) is the number min {A[P] − A[Q], A[R] − A[Q]}. For example, consider array A consisting of 10 elements such that: A[0] = 0 A[1] = 1 A[2] = 3 A[3] = -2 A[4] = 0 A[5] = 1 A[6] = 0 A[7] = -3 A[8] = 2 A[9] = 3 Triplet (2, 3, 4) is
            Read more

            Fotorealismo

            Image
            Guerrino Boatto, Venice's St. Barnaba Church and canal Il fotorealismo è un genere di pittura basato sull'uso di una o più fotografie dalle quali l'artista prende le informazioni necessarie da utilizzare poi nel processo della creazione dell'opera, in genere ad olio o ad acrilico, al fine di avere un aspetto finale il più simile possibile alla fotografia. Indice 1 Storia 2 Lista dei fotorealisti 3 Note 4 Voci correlate 5 Altri progetti Storia | Il fotorealismo è un movimento che nasce negli Stati Uniti d'America alla fine degli anni sessanta [1] sulla scia della Pop Art [2] [3] [4] , e insieme condividono il carattere reazionario verso la travolgente ascesa dei media, che alla metà del ventesimo secolo si trasforma in un fenomeno di massa talmente imponente da minacciare il valore dell'immagine nell'arte. [5] [6] Ne consegue così che, colto il gesto d'inizio che fu della Pop Art, i fotorealisti aprono ad un
            Read more