How to add a Description column's table

[JCooL]

Hi,
i want add a new colum to a data base, u know that in SQL Server we have Owner, Type and Created Day columns about the table in a DB, i need other with my preference text.

Thanx

 

[aalmeida]

Can you send the Current structure of the Table so we can sugest the Best way to change it? AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[JCooL]

i means..

this is the list of a Database i want add other columns like


Name Owner Type Created Day Description
Employeer dbo User 18/03/2002 11:45am Module Employeer
Products dbo User 18/03/2002 11:45am Module Shop
Order dbo User 18/03/2002 11:45am Module Store

thats it...

Thanx...

 

[aalmeida]

Correct me if my assuptions are wrong!

I understand you are trying to change the structure of a SQL Server System Table called "Sysdatabases" that resides on the Master database, if that is the case I recoment you not to make that cjhange since it may crash your server.

Or you are trying to make a change to a user Table on a user databases that retains a list of the databases on you server, that I recoment you to use "ALTER TABLE" you can read all about on BOL search for "ALTER TABLE" AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"