1
resposta

entity framework

estou tentando rodar um comando SQL no siaul studio esta apresentando os sguintes erros

Msg 2714, Level 16, State 6, Line 5 There is already an object named 'actor' in the database. Msg 1781, Level 16, State 1, Line 13 Column already has a DEFAULT bound to it. Msg 1750, Level 16, State 0, Line 13 Could not create constraint or index. See previous errors. Msg 1913, Level 16, State 1, Line 15 The operation failed because an index or statistics with name 'idx_actor_last_name' already exists on table 'actor'. Msg 2714, Level 16, State 6, Line 22 There is already an object named 'language' in the database. Msg 1781, Level 16, State 1, Line 29 Column already has a DEFAULT bound to it. Msg 1750, Level 16, State 0, Line 29 Could not create constraint or index. See previous errors. Msg 2714, Level 16, State 6, Line 36 There is already an object named 'category' in the database. Msg 1781, Level 16, State 1, Line 43 Column already has a DEFAULT bound to it. Msg 1750, Level 16, State 0, Line 43 Could not create constraint or index. See previous errors. Msg 2714, Level 16, State 6, Line 50 There is already an object named 'customer' in the database. Msg 1781, Level 16, State 1, Line 61 Column already has a DEFAULT bound to it. Msg 1750, Level 16, State 0, Line 61 Could not create constraint or index. See previous errors. Msg 1781, Level 16, State 1, Line 63 Column already has a DEFAULT bound to it. Msg 1750, Level 16, State 0, Line 63 Could not create constraint or index. See previous errors. Msg 1913, Level 16, State 1, Line 65 The operation failed because an index or statistics with name 'idx_last_name' already exists on table 'customer'. Msg 2714, Level 16, State 6, Line 72 There is already an object named 'film' in the database. Msg 2714, Level 16, State 5, Line 88 There is already an object named 'check_rating' in the database. Msg 1750, Level 16, State 1, Line 88 Could not create constraint or index. See previous errors. Msg 1781, Level 16, State 1, Line 90 Column already has a DEFAULT bound to it. Msg 1750, Level 16, State 0, Line 90 Could not create constraint or index. See previous errors. Msg 1913, Level 16, State 1, Line 92 The operation failed because an index or statistics with name 'idx_fk_language_id' already exists on table 'film'. Msg 1913, Level 16, State 1, Line 94 The operation failed because an index or statistics with name 'idx_fk_original_language_id' already exists on table 'film'. Msg 2714, Level 16, State 6, Line 102 There is already an object named 'film_actor' in the database. Msg 1781, Level 16, State 1, Line 111 Column already has a DEFAULT bound to it. Msg 1750, Level 16, State 0, Line 111 Could not create constraint or index. See previous errors. Msg 1913, Level 16, State 1, Line 113 The operation failed because an index or statistics with name 'idx_fk_film_actor_film' already exists on table 'film_actor'. Msg 1913, Level 16, State 1, Line 115 The operation failed because an index or statistics with name 'idx_fk_film_actor_actor' already exists on table 'film_actor'. Msg 2714, Level 16, State 6, Line 122 There is already an object named 'film_category' in the database. Msg 1781, Level 16, State 1, Line 131 Column already has a DEFAULT bound to it. Msg 1750, Level 16, State 0, Line 131 Could not create constraint or index. See previous errors. Msg 1913, Level 16, State 1, Line 133 The operation failed because an index or statistics with name 'idx_fk_film_category_film' already exists on table 'film_category'.

1 resposta

Vinicius,

Existem algumas frases aqui...

  • Could not create constraint or index. See previous errors.

  • Não foi possível criar restrição ou índice. Veja erros anteriores.

  • The operation failed because an index or statistics with name 'idx_actor_last_name' already exists on table 'actor'.

  • A operação falhou porque um índice ou estatísticas com o nome 'idx_actor_last_name' já existe na tabela 'actor'.

  • There is already an object named 'language' in the database.

  • Já existe um objeto chamado 'language' no banco de dados.

  • Column already has a DEFAULT bound to it.

  • A coluna já tem um padrão vinculado a ela.

  • Could not create constraint or index. See previous errors.

  • Não foi possível criar restrição ou índice. Veja erros anteriores.

  • There is already an object named 'category' in the database.

  • Já existe um objeto chamado 'category' no banco de dados.

  • Column already has a DEFAULT bound to it.

  • A coluna já tem um padrão vinculado a ela.

...

... err...

...Pergunta:

Tem informações que NÃO podem ser apagadas no seu Banco de Dados ou pode apagá-lo por inteiro e refazê-lo?

[]'s,

Fabio I.