How to change the name of table in SQL Server that is a keyword

user4205741

I used procedure as the name of a table in SQL Server. And I can't do anything now and get error.

I didn't know it is a reserved keyword.

What should I do ?

Piotr Kasprzyk

You can use reserved keywords for table and field names in SQL server when you surround them with square brackets. So

drop table [procedure];

should solve the problem. The other option is to find the table dbo.procedure in Object Explorer, right click it, click Delete and choose OK.

이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.

침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제

에서 수정
0

몇 마디 만하겠습니다

0리뷰
로그인참여 후 검토

관련 기사

분류에서Dev

How to change results to display a different name SQL

분류에서Dev

How to replace a name in the datatable using sql server

분류에서Dev

name server change on restart

분류에서Dev

How to search a column name in all tables in a database in SQL Server 2012?

분류에서Dev

SQL Server Table partitioning

분류에서Dev

how can we change the date format of SQL Server(2008) Database?

분류에서Dev

How can I change properties of FK in SQL Server database project?

분류에서Dev

How to change SQL Connection string from server to Windows authentication

분류에서Dev

How distribute many columns in one table in SQL Server 2012 database

분류에서Dev

How to restrict the length of INTEGER when creating a table in SQL Server?

분류에서Dev

SQL script to change the structure of the table

분류에서Dev

How to use 'In' SQL keyword in Entity Framework?

분류에서Dev

SQL Server : Insert into Relation Table

분류에서Dev

Find Duplicates in SQL Server Table

분류에서Dev

How can I insert a record retrieved from an ms access table into an sql server table?

분류에서Dev

SQL Change in one table automatically change the other table

분류에서Dev

How can I access a SQL Server database with . in name via set-location

분류에서Dev

How to change font inside table

분류에서Dev

how to change xml data into table

분류에서Dev

Change LogOn properties of a SQL server instance

분류에서Dev

How to Use MERGE in SQL Server when you have a compound primary key in the source table

분류에서Dev

How to retrieve data from two tables related using a third table, SQL Server

분류에서Dev

How can I use a CASE condition based on a junction table in SQL Server?

분류에서Dev

Transposing a SQL Server Table without aggregating

분류에서Dev

Excute create table in SQL Server with C++

분류에서Dev

Alter table query plan for sql server 2008

분류에서Dev

Save XML data to SQL Server table

분류에서Dev

SQL Server Table Lock during bulk insert

분류에서Dev

SQL Server: proper use of Select with calendar table

Related 관련 기사

  1. 1

    How to change results to display a different name SQL

  2. 2

    How to replace a name in the datatable using sql server

  3. 3

    name server change on restart

  4. 4

    How to search a column name in all tables in a database in SQL Server 2012?

  5. 5

    SQL Server Table partitioning

  6. 6

    how can we change the date format of SQL Server(2008) Database?

  7. 7

    How can I change properties of FK in SQL Server database project?

  8. 8

    How to change SQL Connection string from server to Windows authentication

  9. 9

    How distribute many columns in one table in SQL Server 2012 database

  10. 10

    How to restrict the length of INTEGER when creating a table in SQL Server?

  11. 11

    SQL script to change the structure of the table

  12. 12

    How to use 'In' SQL keyword in Entity Framework?

  13. 13

    SQL Server : Insert into Relation Table

  14. 14

    Find Duplicates in SQL Server Table

  15. 15

    How can I insert a record retrieved from an ms access table into an sql server table?

  16. 16

    SQL Change in one table automatically change the other table

  17. 17

    How can I access a SQL Server database with . in name via set-location

  18. 18

    How to change font inside table

  19. 19

    how to change xml data into table

  20. 20

    Change LogOn properties of a SQL server instance

  21. 21

    How to Use MERGE in SQL Server when you have a compound primary key in the source table

  22. 22

    How to retrieve data from two tables related using a third table, SQL Server

  23. 23

    How can I use a CASE condition based on a junction table in SQL Server?

  24. 24

    Transposing a SQL Server Table without aggregating

  25. 25

    Excute create table in SQL Server with C++

  26. 26

    Alter table query plan for sql server 2008

  27. 27

    Save XML data to SQL Server table

  28. 28

    SQL Server Table Lock during bulk insert

  29. 29

    SQL Server: proper use of Select with calendar table

뜨겁다태그

보관