29402

Where I can check user-define table type in SQL Server 2008 in SSMS? and how can I insert new column

Question:

I need to add some more columns into my current user-define table type in SQL Server 2008

But I didn't see any table type in particular database under Tables .

Where exactly I need to check and how can I modify the design of existing user-define table type in SQL Server 2008

I'm using SQL SERVER 2008 and SSMS

Where I can find that table in SSMS ,

so that I can go and modify table type.

thanks

for previous question answer

Please can any one help to sql alter type table syntax add column ? how can I insert any new column ... as ALTER is not working.. it is disable

Answer1:

<blockquote>

User-defined types cannot be modified after they are created, because changes could invalidate data in the tables or indexes. To modify a type, you must either drop the type and then re-create it, or issue an ALTER ASSEMBLY statement by using the WITH UNCHECKED DATA clause. For more information, see <a href="http://msdn.microsoft.com/en-us/library/ms186711%28v=sql.105%29.aspx" rel="nofollow">ALTER ASSEMBLY (Transact-SQL).</a>

Points to take care while using user defined table type

1.Default values are not allowed.

2.Primary key must be a persisted column.

3.Check constraint can not be done on non persisted computed columns

4.Non clustered indexes are not allowed.

5.It can't be altered. You have to drop and recreate it.

</blockquote>

Recommend

  • How to change url in “View Cart” button in Woocommerce?
  • ASP.NET 3.5 bind to XML string
  • Handler for fastcgi-script returned invalid result code
  • how to create listview to a grid programmatically
  • Tcl/Tk - Memchan - fifo - how to rename fifo as stdout in a tcl/tk application which has Memchan sta
  • Working with unequal sized dataframes in if-else statement in R
  • CodeIgniter: set_value() or post() - what is faster and what is the best practice to store data into
  • Preloading webView doesn't work - trying to reduce loading time
  • React/Redux. Access state from other component
  • date changes on export kendoGrid
  • Validating a Firebase Key [duplicate]
  • iOS App crash issue `[UIWindow warpPoint:]`
  • How to search for a method or variable name within android project?
  • Smarter Removing Unnecessary WhiteSpace CSV
  • How to convert days into months using datetime in Python3?
  • Firebase: Create/Update multiple child nodes atomically
  • Implementation of timeout in LDAP
  • Getting Microsoft Calibri font on Amazon EC2 ubuntu
  • Javascript inside HTML import not affecting imported HTML
  • Debugging php script timeout?
  • How to use Typescript with libraries like Ampersand.js that parse configs to build prototypes
  • How to use AJAX to upload large CSV file? [closed]
  • Excel File upload in asp.net using SqlBulkCopy
  • Ajax call on Multiple selection in Select box
  • Typeahead.js does give me suggestions but doesn't select them
  • how to get the location(lat/lng) on google maps v3 from the location(x,y)
  • Send array to next viewcontroller iOs xcode [duplicate]
  • How to encrypt Connectionstring written in web.config from codebehind?
  • Computing the discrete fourier transform of audio data with FFTW
  • Make checkout phone field optional for specific countries in WooCommerce
  • calling IO Operations from thread in ruby c extension will cause ruby to hang
  • Angular 4: Responsive Grid List
  • Using Service Component Runtime
  • Write to .csv file with PHP (Commas in Data Error)
  • Access to a Matlab gui from the web
  • convert json to excel in java
  • Create/delete users from text file using Bash script