I have table(Sheet_name) like Sheetname Tblname Ecom Ecom Drug Drug like that. im having tables in my database with these Tblname like Ecom table Im having and Drug table im having. Now i need to rename my tables with Tblname_datepart, the tbl name which is existed in the sheet_name table.how to write a query? can any one heplp me. Thanks in advance.
As mentioned by @SQLGoooRooo, renaming a table is indeed fairly simple however keep in mind that any code that is referencing that table (view w/o schemabinding, stored procedures, functions, entity framework, etc) will need to be updated to reflect the new name otherwise things will potentially cease to function correctly. If you are unsure on what is referencing that table, you can right click the table name and select "View Dependencies" to see what might be referencing it. That however will not tell you of any ORM's that are using it. Hope this helps!