I created a small database with the initial size of 2mb, i then altered it to 5mb I then use the stored procedure sp_helpdb to check the sizes of the...
i created a table: Alter database db Add filegroup music Create table song ( song_id Int Not Null identity(1,1), album_id int Not Null,...
I created a new database but initially the size of the database is 2mb but i altered it so that it increase the size to 5mb but when i used the...
hi i am trying to learn the purpose of this information_schema.tables view from my understand it shows a list of all the tables if i had create a new...
i created a database called db1 and i used an alter statement to increase the size of the model database to 10 mb later on i want to create the...
<div id="post_message_118196">I created the table apple in the 'a'schema. The table . The table have the following columns: b_id (primaryid column),...
Alter database db1 Add log file ( Name = db1 Filename = db1.log Size = 1MB, Maxsize = 10MB, Filegrowth = 10%) How do I add a...
I created a role called user and would like to insert rows in 2 tablescalled tbl1 and tbl2 and i am adding the user that is created to be themember...
I created three different tables: order customer product I need 2 many-to-many table for order and customer customer and product Create table...
I have a table called Orders and i added a column called 'order_name' I would like to know how to check thecolumns of the Orders table using two...
Separate names with a comma.
