Hi Guest 1 HomePage 1 Jobs 1 WalkIn 1Articles  

 :) Latest Topic
AJAX
VB.NET
SQL Query
UDDI
CLASS
JavaScript Questions
SharePoint Interview
SilverLight
WCF
general knowledge
 ASP.NET
 :) Hot Jobs
 
 :) Latest Articles


  

 
How to change schema name of the Table in SQL Like dbo to crackuser?
Question Posted on 12 Sep 2021

Home >> DataBase >> SQL Query >> How to change schema name of the Table in SQL Like dbo to crackuser?




How to change schema name of the Table in SQL Like dbo to crackuser?
TO change schema name of the table we need only alter command as given below

ALTER SCHEMA crackuser TRANSFER dbo.table_name

There are some situation where we are not able to find the schema name in SQL. SO to creat that we use below query to create schema.


IF (NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'crackuser'))
BEGIN
EXEC ('CREATE SCHEMA [crackuser] AUTHORIZATION [dbo]')
END



Other Important Questions
How to get the table count in last used query from cache by sending tablename?
Write a SQL query to print 1 to 100 in sql server?
Sql Interview Latest Query questions asked on 30 dec 2020
nth highest number from table
some good sql query






Hello Sir/Madam as Covid is spreading we request you to please take care your self and visit helpsthepoor.com

 
Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |