Ne mozes da ih 'izbacis', ali mozes da ih sakrijes da se ne vide :-)
U SQL Manager prozoru:
- Right Click na server pa onda
- idi u "Edit SQL server Registration properties",
- pod "Options", nadji "show System databases and system objects" i iskljuci
mislio sam kroz upit to da prikazem, nesto ovako, samo sto ne razumem kako radi i kako da primenim na moju bazu:
SELECT
TableName = O.name, ObjectType = O.xtype, ObjectID = O.id ,
ColumnName = C.name, C.Xtype, ColumnOrder = C.colorder,
ColumnType = T.Name, C.Length, C.Xprec, C.scale
FROM sysobjects AS O
JOIN syscolumns AS C ON C.Id = O.ID
JOIN systypes AS T ON t.xtype = C.xtype
WHERE O.xtype = 'U'
AND O.Name = 'Tabela1'
ORDER BY O.name, C.colorder
[Ovu poruku je menjao Milunov_Mali dana 03.04.2007. u 01:46 GMT+1]