Rename Signatory Cc Number with airSlate SignNow

Rename esign attempt

welcome to tech brother Dahmer in this video we are going to learn how to rename all default constraints according to the naming convention or standards in sequel server database so think about a scenario you are working as a sequel server developer and your manager or team team leader has asked you can you check if for our objects such as a default constraint specially are named following the name and standard what we have in the company so maybe they have a naming convention or for the default constraints such as it should always start with the BF then they should have schema then they should have table name and then there should be a column name and maybe a value for the default constraint but we have used them so you would like to take a he is asked enough to provide the definition and all that and if you can provide it okay fine and then from there if we need to rename so in this scenario I have opposed to written here if you want to take a look like whatever the values are you can go from there let me show you on the tech brothers IT you you are under the sequel server TC equal tutorial or tab and once you are there on chapter 6 you have this information so we have default constraint the very first is how to get the list of all default constraints with the names and all that so click on that one copy this query and this will provide you definition and everything go so let's delete okay leave this one else it is and now run the Select query and we see that in a tech brothers IT database these are the schemas these are the tables and these are the columns and here we have the default constraints created on these columns and here we have the values of for those are default constraints now this information you can provide to your manager and he would understand okay none of these let's say these four of them the they are not following the name and standard maybe these two are okay because we have you start with DF we have schema name table name and column name but these are other constraints are not following the name in conventional he would like to create a script so you can rename all of them now that's a not difficult part you can always go and use the SP underscore rename a store procedure and you have to provide the older where old name and then you have to have the new name what you like so old name and comma new name so this is how the script will be but you need to create maybe you have hundreds of for these default constraints which are created by the sequel server nobody provide the correct name while they were creating with these default constraints so...